Overview

Dataset statistics

Number of variables151
Number of observations2260701
Missing cells108486249
Missing cells (%)31.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.3 GiB
Average record size in memory2.9 KiB

Variable types

NUM109
CAT36
BOOL4
UNSUPPORTED1
URL1

Reproduction

Analysis started2020-10-29 16:52:58.375050
Analysis finished2020-10-29 17:03:27.534580
Versionpandas-profiling v2.6.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
id has a high cardinality: 2260701 distinct values High cardinality
emp_title has a high cardinality: 512694 distinct values High cardinality
issue_d has a high cardinality: 139 distinct values High cardinality
desc has a high cardinality: 124501 distinct values High cardinality
title has a high cardinality: 63155 distinct values High cardinality
zip_code has a high cardinality: 956 distinct values High cardinality
addr_state has a high cardinality: 51 distinct values High cardinality
earliest_cr_line has a high cardinality: 754 distinct values High cardinality
last_pymnt_d has a high cardinality: 136 distinct values High cardinality
next_pymnt_d has a high cardinality: 106 distinct values High cardinality
last_credit_pull_d has a high cardinality: 141 distinct values High cardinality
sec_app_earliest_cr_line has a high cardinality: 663 distinct values High cardinality
debt_settlement_flag_date has a high cardinality: 83 distinct values High cardinality
settlement_date has a high cardinality: 90 distinct values High cardinality
member_id has 2260701 (100.0%) missing values Missing
emp_title has 167002 (7.4%) missing values Missing
emp_length has 146940 (6.5%) missing values Missing
desc has 2134634 (94.4%) missing values Missing
title has 23358 (1.0%) missing values Missing
mths_since_last_delinq has 1158535 (51.2%) missing values Missing
mths_since_last_record has 1901545 (84.1%) missing values Missing
next_pymnt_d has 1345343 (59.5%) missing values Missing
mths_since_last_major_derog has 1679926 (74.3%) missing values Missing
annual_inc_joint has 2139991 (94.7%) missing values Missing
dti_joint has 2139995 (94.7%) missing values Missing
verification_status_joint has 2144971 (94.9%) missing values Missing
tot_coll_amt has 70309 (3.1%) missing values Missing
tot_cur_bal has 70309 (3.1%) missing values Missing
open_acc_6m has 866163 (38.3%) missing values Missing
open_act_il has 866162 (38.3%) missing values Missing
open_il_12m has 866162 (38.3%) missing values Missing
open_il_24m has 866162 (38.3%) missing values Missing
mths_since_rcnt_il has 909957 (40.3%) missing values Missing
total_bal_il has 866162 (38.3%) missing values Missing
il_util has 1068883 (47.3%) missing values Missing
open_rv_12m has 866162 (38.3%) missing values Missing
open_rv_24m has 866162 (38.3%) missing values Missing
max_bal_bc has 866162 (38.3%) missing values Missing
all_util has 866381 (38.3%) missing values Missing
total_rev_hi_lim has 70309 (3.1%) missing values Missing
inq_fi has 866162 (38.3%) missing values Missing
total_cu_tl has 866163 (38.3%) missing values Missing
inq_last_12m has 866163 (38.3%) missing values Missing
acc_open_past_24mths has 50063 (2.2%) missing values Missing
avg_cur_bal has 70379 (3.1%) missing values Missing
bc_open_to_buy has 74968 (3.3%) missing values Missing
bc_util has 76104 (3.4%) missing values Missing
mo_sin_old_il_acct has 139104 (6.2%) missing values Missing
mo_sin_old_rev_tl_op has 70310 (3.1%) missing values Missing
mo_sin_rcnt_rev_tl_op has 70310 (3.1%) missing values Missing
mo_sin_rcnt_tl has 70309 (3.1%) missing values Missing
mort_acc has 50063 (2.2%) missing values Missing
mths_since_recent_bc has 73445 (3.2%) missing values Missing
mths_since_recent_bc_dlq has 1741000 (77.0%) missing values Missing
mths_since_recent_inq has 295468 (13.1%) missing values Missing
mths_since_recent_revol_delinq has 1520342 (67.3%) missing values Missing
num_accts_ever_120_pd has 70309 (3.1%) missing values Missing
num_actv_bc_tl has 70309 (3.1%) missing values Missing
num_actv_rev_tl has 70309 (3.1%) missing values Missing
num_bc_sats has 58623 (2.6%) missing values Missing
num_bc_tl has 70309 (3.1%) missing values Missing
num_il_tl has 70309 (3.1%) missing values Missing
num_op_rev_tl has 70309 (3.1%) missing values Missing
num_rev_accts has 70310 (3.1%) missing values Missing
num_rev_tl_bal_gt_0 has 70309 (3.1%) missing values Missing
num_sats has 58623 (2.6%) missing values Missing
num_tl_120dpd_2m has 153690 (6.8%) missing values Missing
num_tl_30dpd has 70309 (3.1%) missing values Missing
num_tl_90g_dpd_24m has 70309 (3.1%) missing values Missing
num_tl_op_past_12m has 70309 (3.1%) missing values Missing
pct_tl_nvr_dlq has 70464 (3.1%) missing values Missing
percent_bc_gt_75 has 75412 (3.3%) missing values Missing
tot_hi_cred_lim has 70309 (3.1%) missing values Missing
total_bal_ex_mort has 50063 (2.2%) missing values Missing
total_bc_limit has 50063 (2.2%) missing values Missing
total_il_high_credit_limit has 70309 (3.1%) missing values Missing
revol_bal_joint has 2152681 (95.2%) missing values Missing
sec_app_fico_range_low has 2152680 (95.2%) missing values Missing
sec_app_fico_range_high has 2152680 (95.2%) missing values Missing
sec_app_earliest_cr_line has 2152680 (95.2%) missing values Missing
sec_app_inq_last_6mths has 2152680 (95.2%) missing values Missing
sec_app_mort_acc has 2152680 (95.2%) missing values Missing
sec_app_open_acc has 2152680 (95.2%) missing values Missing
sec_app_revol_util has 2154517 (95.3%) missing values Missing
sec_app_open_act_il has 2152680 (95.2%) missing values Missing
sec_app_num_rev_accts has 2152680 (95.2%) missing values Missing
sec_app_chargeoff_within_12_mths has 2152680 (95.2%) missing values Missing
sec_app_collections_12_mths_ex_med has 2152680 (95.2%) missing values Missing
sec_app_mths_since_last_major_derog has 2224759 (98.4%) missing values Missing
hardship_type has 2249784 (99.5%) missing values Missing
hardship_reason has 2249784 (99.5%) missing values Missing
hardship_status has 2249784 (99.5%) missing values Missing
deferral_term has 2249784 (99.5%) missing values Missing
hardship_amount has 2249784 (99.5%) missing values Missing
hardship_start_date has 2249784 (99.5%) missing values Missing
hardship_end_date has 2249784 (99.5%) missing values Missing
payment_plan_start_date has 2249784 (99.5%) missing values Missing
hardship_length has 2249784 (99.5%) missing values Missing
hardship_dpd has 2249784 (99.5%) missing values Missing
hardship_loan_status has 2249784 (99.5%) missing values Missing
orig_projected_additional_accrued_interest has 2252050 (99.6%) missing values Missing
hardship_payoff_balance_amount has 2249784 (99.5%) missing values Missing
hardship_last_payment_amount has 2249784 (99.5%) missing values Missing
debt_settlement_flag_date has 2226455 (98.5%) missing values Missing
settlement_status has 2226455 (98.5%) missing values Missing
settlement_date has 2226455 (98.5%) missing values Missing
settlement_amount has 2226455 (98.5%) missing values Missing
settlement_percentage has 2226455 (98.5%) missing values Missing
settlement_term has 2226455 (98.5%) missing values Missing
annual_inc is highly skewed (γ1 = 493.8860884) Skewed
dti is highly skewed (γ1 = 29.20185447) Skewed
total_rec_late_fee is highly skewed (γ1 = 21.90352305) Skewed
annual_inc_joint is highly skewed (γ1 = 21.7445355) Skewed
acc_now_delinq is highly skewed (γ1 = 22.90797767) Skewed
tot_coll_amt is highly skewed (γ1 = 852.0101323) Skewed
total_rev_hi_lim is highly skewed (γ1 = 32.55742738) Skewed
delinq_amnt is highly skewed (γ1 = 102.6547743) Skewed
num_tl_120dpd_2m is highly skewed (γ1 = 55.80984712) Skewed
num_tl_30dpd is highly skewed (γ1 = 22.51746312) Skewed
tax_liens is highly skewed (γ1 = 32.07091145) Skewed
sec_app_chargeoff_within_12_mths is highly skewed (γ1 = 20.27699345) Skewed
member_id is an unsupported type, check if it needs cleaning or further analysis Rejected
delinq_2yrs has 1839108 (81.4%) zeros Zeros
inq_last_6mths has 1381722 (61.1%) zeros Zeros
pub_rec has 1902758 (84.2%) zeros Zeros
out_prncp has 1352764 (59.8%) zeros Zeros
out_prncp_inv has 1352764 (59.8%) zeros Zeros
total_rec_late_fee has 2173513 (96.1%) zeros Zeros
recoveries has 2075236 (91.8%) zeros Zeros
collection_recovery_fee has 2083655 (92.2%) zeros Zeros
last_fico_range_low has 37326 (1.7%) zeros Zeros
collections_12_mths_ex_med has 2223085 (98.3%) zeros Zeros
acc_now_delinq has 2251857 (99.6%) zeros Zeros
tot_coll_amt has 1856129 (82.1%) zeros Zeros
open_acc_6m has 627966 (27.8%) zeros Zeros
open_act_il has 165848 (7.3%) zeros Zeros
open_il_12m has 760254 (33.6%) zeros Zeros
open_il_24m has 377489 (16.7%) zeros Zeros
total_bal_il has 158666 (7.0%) zeros Zeros
open_rv_12m has 513716 (22.7%) zeros Zeros
open_rv_24m has 223783 (9.9%) zeros Zeros
max_bal_bc has 35917 (1.6%) zeros Zeros
inq_fi has 697142 (30.8%) zeros Zeros
total_cu_tl has 753128 (33.3%) zeros Zeros
inq_last_12m has 400090 (17.7%) zeros Zeros
acc_open_past_24mths has 100270 (4.4%) zeros Zeros
bc_open_to_buy has 30767 (1.4%) zeros Zeros
bc_util has 27885 (1.2%) zeros Zeros
chargeoff_within_12_mths has 2243339 (99.2%) zeros Zeros
delinq_amnt has 2253465 (99.7%) zeros Zeros
mo_sin_rcnt_rev_tl_op has 33747 (1.5%) zeros Zeros
mo_sin_rcnt_tl has 34923 (1.5%) zeros Zeros
mort_acc has 929606 (41.1%) zeros Zeros
mths_since_recent_inq has 168927 (7.5%) zeros Zeros
num_accts_ever_120_pd has 1687416 (74.6%) zeros Zeros
num_actv_bc_tl has 50061 (2.2%) zeros Zeros
num_bc_sats has 23661 (1.0%) zeros Zeros
num_il_tl has 68944 (3.0%) zeros Zeros
num_tl_120dpd_2m has 2105738 (93.1%) zeros Zeros
num_tl_30dpd has 2184561 (96.6%) zeros Zeros
num_tl_90g_dpd_24m has 2073060 (91.7%) zeros Zeros
num_tl_op_past_12m has 415975 (18.4%) zeros Zeros
percent_bc_gt_75 has 598711 (26.5%) zeros Zeros
pub_rec_bankruptcies has 1987383 (87.9%) zeros Zeros
tax_liens has 2195933 (97.1%) zeros Zeros
total_bc_limit has 25349 (1.1%) zeros Zeros
total_il_high_credit_limit has 263497 (11.7%) zeros Zeros
sec_app_inq_last_6mths has 65252 (2.9%) zeros Zeros
sec_app_mort_acc has 42218 (1.9%) zeros Zeros
sec_app_chargeoff_within_12_mths has 105117 (4.6%) zeros Zeros
sec_app_collections_12_mths_ex_med has 101793 (4.5%) zeros Zeros

Variables

id
Categorical

HIGH CARDINALITY
UNIQUE
Distinct count2260701
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size17.2 MiB
88212630
 
1
442699
 
1
10587954
 
1
32068496
 
1
91141406
 
1
Other values (2260696)
2260696
ValueCountFrequency (%) 
88212630 1 < 0.1%
 
442699 1 < 0.1%
 
10587954 1 < 0.1%
 
32068496 1 < 0.1%
 
91141406 1 < 0.1%
 
59749709 1 < 0.1%
 
18354424 1 < 0.1%
 
13777717 1 < 0.1%
 
134505745 1 < 0.1%
 
7619564 1 < 0.1%
 
Other values (2260691) 2260691 > 99.9%
 

member_id
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing2260701
Missing (%)100.0%
Memory size17.2 MiB

loan_amnt
Real number (ℝ≥0)

Distinct count1572
Unique (%)0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15046.93123
Minimum500
Maximum40000
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum500
5-th percentile3250
Q18000
median12900
Q320000
95-th percentile35000
Maximum40000
Range39500
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9190.245488
Coefficient of variation (CV)0.6107720803
Kurtosis-0.1194391577
Mean15046.93123
Median Absolute Deviation (MAD)7445.307472
Skewness0.7777823287
Sum3.401611592e+10
Variance84460612.13
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 187236 8.3%
 
20000 131006 5.8%
 
15000 123226 5.5%
 
12000 121681 5.4%
 
35000 86285 3.8%
 
5000 84765 3.7%
 
8000 75033 3.3%
 
6000 72089 3.2%
 
25000 66453 2.9%
 
16000 66418 2.9%
 
Other values (1562) 1246476 55.1%
 
ValueCountFrequency (%) 
500 11 < 0.1%
 
550 1 < 0.1%
 
600 6 < 0.1%
 
700 3 < 0.1%
 
725 1 < 0.1%
 
ValueCountFrequency (%) 
40000 33368 1.5%
 
39975 11 < 0.1%
 
39950 10 < 0.1%
 
39925 14 < 0.1%
 
39900 24 < 0.1%
 

funded_amnt
Real number (ℝ≥0)

Distinct count1572
Unique (%)0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15041.66406
Minimum500
Maximum40000
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum500
5-th percentile3250
Q18000
median12875
Q320000
95-th percentile35000
Maximum40000
Range39500
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9188.413022
Coefficient of variation (CV)0.6108641296
Kurtosis-0.1170090387
Mean15041.66406
Median Absolute Deviation (MAD)7442.540455
Skewness0.7787785936
Sum3.40042086e+10
Variance84426933.87
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 187146 8.3%
 
20000 130816 5.8%
 
15000 123110 5.4%
 
12000 121588 5.4%
 
35000 86147 3.8%
 
5000 84751 3.7%
 
8000 75020 3.3%
 
6000 72075 3.2%
 
16000 66331 2.9%
 
25000 66176 2.9%
 
Other values (1562) 1247508 55.2%
 
ValueCountFrequency (%) 
500 11 < 0.1%
 
550 1 < 0.1%
 
600 6 < 0.1%
 
700 3 < 0.1%
 
725 1 < 0.1%
 
ValueCountFrequency (%) 
40000 33368 1.5%
 
39975 11 < 0.1%
 
39950 10 < 0.1%
 
39925 14 < 0.1%
 
39900 24 < 0.1%
 

funded_amnt_inv
Real number (ℝ≥0)

Distinct count10057
Unique (%)0.4%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean15023.43775
Minimum0
Maximum40000
Zeros233
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile3200
Q18000
median12800
Q320000
95-th percentile35000
Maximum40000
Range40000
Interquartile range (IQR)12000

Descriptive statistics

Standard deviation9192.331679
Coefficient of variation (CV)0.6118660612
Kurtosis-0.1166814573
Mean15023.43775
Median Absolute Deviation (MAD)7444.677901
Skewness0.7782542751
Sum3.396300496e+10
Variance84498961.69
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 177561 7.9%
 
20000 120453 5.3%
 
15000 114539 5.1%
 
12000 114068 5.0%
 
5000 81999 3.6%
 
35000 76093 3.4%
 
8000 71528 3.2%
 
6000 69475 3.1%
 
16000 61840 2.7%
 
25000 60610 2.7%
 
Other values (10047) 1312502 58.1%
 
ValueCountFrequency (%) 
0 233 < 0.1%
 
0.000121098108 1 < 0.1%
 
0.000185369401 1 < 0.1%
 
0.000242055511 1 < 0.1%
 
0.000531133069 1 < 0.1%
 
ValueCountFrequency (%) 
40000 31767 1.4%
 
39975 616 < 0.1%
 
39950 218 < 0.1%
 
39925 58 < 0.1%
 
39900 29 < 0.1%
 

term
Categorical

Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
36 months
1609754
60 months
650914
ValueCountFrequency (%) 
36 months 1609754 71.2%
 
60 months 650914 28.8%
 
(Missing) 33 < 0.1%
 

int_rate
Real number (ℝ≥0)

Distinct count673
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean13.09282911
Minimum5.31
Maximum30.99
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum5.31
5-th percentile6.49
Q19.49
median12.62
Q315.99
95-th percentile22.15
Maximum30.99
Range25.68
Interquartile range (IQR)6.5

Descriptive statistics

Standard deviation4.832138365
Coefficient of variation (CV)0.36906755
Kurtosis0.5940245697
Mean13.09282911
Median Absolute Deviation (MAD)3.799125792
Skewness0.7680705625
Sum29598539.81
Variance23.34956117
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11.99 53869 2.4%
 
5.32 47171 2.1%
 
10.99 44165 2.0%
 
13.99 43025 1.9%
 
11.49 32010 1.4%
 
16.99 30564 1.4%
 
12.99 29276 1.3%
 
7.89 28514 1.3%
 
9.17 27835 1.2%
 
15.61 25208 1.1%
 
Other values (663) 1899031 84.0%
 
ValueCountFrequency (%) 
5.31 8613 0.4%
 
5.32 47171 2.1%
 
5.42 573 < 0.1%
 
5.79 410 < 0.1%
 
5.93 1812 0.1%
 
ValueCountFrequency (%) 
30.99 819 < 0.1%
 
30.94 733 < 0.1%
 
30.89 699 < 0.1%
 
30.84 755 < 0.1%
 
30.79 1572 0.1%
 

installment
Real number (ℝ≥0)

Distinct count93301
Unique (%)4.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean445.8068229
Minimum4.93
Maximum1719.83
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum4.93
5-th percentile110.43
Q1251.65
median377.99
Q3593.32
95-th percentile984.47
Maximum1719.83
Range1714.9
Interquartile range (IQR)341.67

Descriptive statistics

Standard deviation267.1735346
Coefficient of variation (CV)0.5993033774
Kurtosis0.6898790426
Mean445.8068229
Median Absolute Deviation (MAD)211.60717
Skewness1.001780569
Sum1007821219
Variance71381.6976
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
301.15 4420 0.2%
 
332.1 4153 0.2%
 
361.38 3704 0.2%
 
327.34 3353 0.1%
 
602.3 3095 0.1%
 
451.73 3076 0.1%
 
329.72 2614 0.1%
 
166.05 2508 0.1%
 
498.15 2410 0.1%
 
180.69 2364 0.1%
 
Other values (93291) 2228971 98.6%
 
ValueCountFrequency (%) 
4.93 1 < 0.1%
 
7.61 1 < 0.1%
 
14.01 1 < 0.1%
 
14.77 1 < 0.1%
 
15.67 1 < 0.1%
 
ValueCountFrequency (%) 
1719.83 2 < 0.1%
 
1717.63 1 < 0.1%
 
1715.42 2 < 0.1%
 
1714.54 6 < 0.1%
 
1691.28 2 < 0.1%
 

grade
Categorical

Distinct count7
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
B
663557
C
650053
A
433027
D
324424
E
135639
Other values (2)
 
53968
ValueCountFrequency (%) 
B 663557 29.4%
 
C 650053 28.8%
 
A 433027 19.2%
 
D 324424 14.4%
 
E 135639 6.0%
 
F 41800 1.8%
 
G 12168 0.5%
 
(Missing) 33 < 0.1%
 

sub_grade
Categorical

Distinct count35
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
C1
 
145903
B5
 
140288
B4
 
139793
B3
 
131514
C2
 
131116
Other values (30)
1572054
ValueCountFrequency (%) 
C1 145903 6.5%
 
B5 140288 6.2%
 
B4 139793 6.2%
 
B3 131514 5.8%
 
C2 131116 5.8%
 
C3 129193 5.7%
 
C4 127115 5.6%
 
B2 126621 5.6%
 
B1 125341 5.5%
 
C5 116726 5.2%
 
Other values (25) 947058 41.9%
 

emp_title
Categorical

HIGH CARDINALITY
MISSING
Distinct count512694
Unique (%)24.5%
Missing167002
Missing (%)7.4%
Memory size17.2 MiB
Teacher
 
38824
Manager
 
34298
Owner
 
21977
Registered Nurse
 
15867
Driver
 
14753
Other values (512689)
1967980
ValueCountFrequency (%) 
Teacher 38824 1.7%
 
Manager 34298 1.5%
 
Owner 21977 1.0%
 
Registered Nurse 15867 0.7%
 
Driver 14753 0.7%
 
RN 14737 0.7%
 
Supervisor 14297 0.6%
 
Sales 13050 0.6%
 
Project Manager 10971 0.5%
 
Office Manager 9772 0.4%
 
Other values (512684) 1905153 84.3%
 
(Missing) 167002 7.4%
 

emp_length
Categorical

MISSING
Distinct count11
Unique (%)< 0.1%
Missing146940
Missing (%)6.5%
Memory size17.2 MiB
10+ years
748005
2 years
203677
< 1 year
189988
3 years
180753
1 year
 
148403
Other values (6)
642935
ValueCountFrequency (%) 
10+ years 748005 33.1%
 
2 years 203677 9.0%
 
< 1 year 189988 8.4%
 
3 years 180753 8.0%
 
1 year 148403 6.6%
 
5 years 139698 6.2%
 
4 years 136605 6.0%
 
6 years 102628 4.5%
 
7 years 92695 4.1%
 
8 years 91914 4.1%
 
(Missing) 146940 6.5%
 

home_ownership
Categorical

Distinct count6
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
MORTGAGE
1111450
RENT
894929
OWN
253057
ANY
 
996
OTHER
 
182
ValueCountFrequency (%) 
MORTGAGE 1111450 49.2%
 
RENT 894929 39.6%
 
OWN 253057 11.2%
 
ANY 996 < 0.1%
 
OTHER 182 < 0.1%
 
NONE 54 < 0.1%
 
(Missing) 33 < 0.1%
 

annual_inc
Real number (ℝ≥0)

SKEWED
Distinct count89368
Unique (%)4.0%
Missing37
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean77992.42869
Minimum0
Maximum110000000
Zeros1667
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile27600
Q146000
median65000
Q393000
95-th percentile160000
Maximum110000000
Range110000000
Interquartile range (IQR)47000

Descriptive statistics

Standard deviation112696.1996
Coefficient of variation (CV)1.444963331
Kurtosis439001.6589
Mean77992.42869
Median Absolute Deviation (MAD)34549.45122
Skewness493.8860884
Sum1.763146758e+11
Variance1.27004334e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
60000 87189 3.9%
 
50000 76355 3.4%
 
65000 64903 2.9%
 
70000 62078 2.7%
 
80000 59833 2.6%
 
40000 59684 2.6%
 
75000 58459 2.6%
 
45000 54534 2.4%
 
55000 51583 2.3%
 
100000 46977 2.1%
 
Other values (89358) 1639069 72.5%
 
ValueCountFrequency (%) 
0 1667 0.1%
 
0.36 1 < 0.1%
 
1 42 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
ValueCountFrequency (%) 
110000000 1 < 0.1%
 
61000000 1 < 0.1%
 
10999200 1 < 0.1%
 
9930475 1 < 0.1%
 
9757200 1 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Source Verified
886231
Not Verified
744806
Verified
629631
ValueCountFrequency (%) 
Source Verified 886231 39.2%
 
Not Verified 744806 32.9%
 
Verified 629631 27.9%
 
(Missing) 33 < 0.1%
 

issue_d
Categorical

HIGH CARDINALITY
Distinct count139
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Mar-2016
 
61992
Oct-2015
 
48631
May-2018
 
46311
Oct-2018
 
46305
Aug-2018
 
46079
Other values (134)
2011350
ValueCountFrequency (%) 
Mar-2016 61992 2.7%
 
Oct-2015 48631 2.2%
 
May-2018 46311 2.0%
 
Oct-2018 46305 2.0%
 
Aug-2018 46079 2.0%
 
Jul-2015 45962 2.0%
 
Dec-2015 44343 2.0%
 
Aug-2017 43573 1.9%
 
Jul-2018 43089 1.9%
 
Apr-2018 42928 1.9%
 
Other values (129) 1791455 79.2%
 

loan_status
Categorical

Distinct count9
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Fully Paid
1076751
Current
878317
Charged Off
268559
Late (31-120 days)
 
21467
In Grace Period
 
8436
Other values (4)
 
7138
ValueCountFrequency (%) 
Fully Paid 1076751 47.6%
 
Current 878317 38.9%
 
Charged Off 268559 11.9%
 
Late (31-120 days) 21467 0.9%
 
In Grace Period 8436 0.4%
 
Late (16-30 days) 4349 0.2%
 
Does not meet the credit policy. Status:Fully Paid 1988 0.1%
 
Does not meet the credit policy. Status:Charged Off 761 < 0.1%
 
Default 40 < 0.1%
 
(Missing) 33 < 0.1%
 

pymnt_plan
Boolean

Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
n
2260048
y
 
620
(Missing)
 
33
ValueCountFrequency (%) 
n 2260048 > 99.9%
 
y 620 < 0.1%
 
(Missing) 33 < 0.1%
 

url
URL

Distinct count2260668
Unique (%)100.0%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
https://lendingclub.com/browse/loanDetail.action?loan_id=41120479
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=109800184
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=113993186
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=132660157
 
1
https://lendingclub.com/browse/loanDetail.action?loan_id=131351332
 
1
Other values (2260663)
2260663
(Missing)
 
33
ValueCountFrequency (%) 
https://lendingclub.com/browse/loanDetail.action?loan_id=41120479 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=109800184 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=113993186 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=132660157 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=131351332 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=60306071 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=73914843 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=84080681 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=124931866 1 < 0.1%
 
https://lendingclub.com/browse/loanDetail.action?loan_id=143457729 1 < 0.1%
 
Other values (2260658) 2260658 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
https 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
lendingclub.com 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
/browse/loanDetail.action 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
loan_id=94341855 1 < 0.1%
 
loan_id=130789955 1 < 0.1%
 
loan_id=85701657 1 < 0.1%
 
loan_id=874557 1 < 0.1%
 
loan_id=11716032 1 < 0.1%
 
loan_id=132918010 1 < 0.1%
 
loan_id=74816440 1 < 0.1%
 
loan_id=67818343 1 < 0.1%
 
loan_id=17212696 1 < 0.1%
 
loan_id=70091510 1 < 0.1%
 
Other values (2260658) 2260658 > 99.9%
 
(Missing) 33 < 0.1%
 
ValueCountFrequency (%) 
2260668 > 99.9%
 
(Missing) 33 < 0.1%
 

desc
Categorical

HIGH CARDINALITY
MISSING
Distinct count124501
Unique (%)98.8%
Missing2134634
Missing (%)94.4%
Memory size17.2 MiB
 
252
Debt Consolidation
 
13
Borrower added on 03/17/14 > Debt consolidation<br>
 
11
Borrower added on 03/10/14 > Debt consolidation<br>
 
10
Borrower added on 02/19/14 > Debt consolidation<br>
 
9
Other values (124496)
125772
ValueCountFrequency (%) 
252 < 0.1%
 
Debt Consolidation 13 < 0.1%
 
Borrower added on 03/17/14 > Debt consolidation<br> 11 < 0.1%
 
Borrower added on 03/10/14 > Debt consolidation<br> 10 < 0.1%
 
Borrower added on 02/19/14 > Debt consolidation<br> 9 < 0.1%
 
Borrower added on 01/29/14 > Debt consolidation<br> 8 < 0.1%
 
Camping Membership 8 < 0.1%
 
Borrower added on 01/22/14 > Debt consolidation<br> 7 < 0.1%
 
Borrower added on 01/15/14 > Debt consolidation<br> 7 < 0.1%
 
Borrower added on 03/03/14 > Debt consolidation<br> 6 < 0.1%
 
Other values (124491) 125736 5.6%
 
(Missing) 2134634 94.4%
 

purpose
Categorical

Distinct count14
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
debt_consolidation
1277877
credit_card
516971
home_improvement
 
150457
other
 
139440
major_purchase
 
50445
Other values (9)
 
125478
ValueCountFrequency (%) 
debt_consolidation 1277877 56.5%
 
credit_card 516971 22.9%
 
home_improvement 150457 6.7%
 
other 139440 6.2%
 
major_purchase 50445 2.2%
 
medical 27488 1.2%
 
small_business 24689 1.1%
 
car 24013 1.1%
 
vacation 15525 0.7%
 
moving 15403 0.7%
 
Other values (4) 18360 0.8%
 

title
Categorical

HIGH CARDINALITY
MISSING
Distinct count63155
Unique (%)2.8%
Missing23358
Missing (%)1.0%
Memory size17.2 MiB
Debt consolidation
1153293
Credit card refinancing
469691
Home improvement
 
137437
Other
 
127714
Major purchase
 
44840
Other values (63150)
304368
ValueCountFrequency (%) 
Debt consolidation 1153293 51.0%
 
Credit card refinancing 469691 20.8%
 
Home improvement 137437 6.1%
 
Other 127714 5.6%
 
Major purchase 44840 2.0%
 
Medical expenses 25388 1.1%
 
Business 20804 0.9%
 
Car financing 20526 0.9%
 
Debt Consolidation 15763 0.7%
 
Vacation 14443 0.6%
 
Other values (63145) 207444 9.2%
 
(Missing) 23358 1.0%
 

zip_code
Categorical

HIGH CARDINALITY
Distinct count956
Unique (%)< 0.1%
Missing34
Missing (%)< 0.1%
Memory size17.2 MiB
112xx
 
23908
945xx
 
23782
750xx
 
23649
606xx
 
21192
300xx
 
20497
Other values (951)
2147639
ValueCountFrequency (%) 
112xx 23908 1.1%
 
945xx 23782 1.1%
 
750xx 23649 1.0%
 
606xx 21192 0.9%
 
300xx 20497 0.9%
 
331xx 19051 0.8%
 
070xx 18316 0.8%
 
770xx 17719 0.8%
 
891xx 17162 0.8%
 
100xx 17103 0.8%
 
Other values (946) 2058288 91.0%
 

addr_state
Categorical

HIGH CARDINALITY
Distinct count51
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
CA
314533
NY
 
186389
TX
 
186335
FL
 
161991
IL
 
91173
Other values (46)
1320247
ValueCountFrequency (%) 
CA 314533 13.9%
 
NY 186389 8.2%
 
TX 186335 8.2%
 
FL 161991 7.2%
 
IL 91173 4.0%
 
NJ 83132 3.7%
 
PA 76939 3.4%
 
OH 75132 3.3%
 
GA 74196 3.3%
 
VA 62954 2.8%
 
Other values (41) 947894 41.9%
 

dti
Real number (ℝ)

SKEWED
Distinct count10845
Unique (%)0.5%
Missing1744
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean18.82419644
Minimum-1
Maximum999
Zeros1732
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum-1
5-th percentile4.94
Q111.89
median17.84
Q324.49
95-th percentile33.88
Maximum999
Range1000
Interquartile range (IQR)12.6

Descriptive statistics

Standard deviation14.18332854
Coefficient of variation (CV)0.7534626294
Kurtosis1755.261278
Mean18.82419644
Median Absolute Deviation (MAD)7.567932162
Skewness29.20185447
Sum42523050.31
Variance201.1668086
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1732 0.1%
 
18 1584 0.1%
 
14.4 1577 0.1%
 
16.8 1576 0.1%
 
19.2 1566 0.1%
 
15.6 1506 0.1%
 
13.2 1496 0.1%
 
12 1486 0.1%
 
20.4 1424 0.1%
 
21.6 1391 0.1%
 
Other values (10835) 2243619 99.2%
 
(Missing) 1744 0.1%
 
ValueCountFrequency (%) 
-1 2 < 0.1%
 
0 1732 0.1%
 
0.01 22 < 0.1%
 
0.02 35 < 0.1%
 
0.03 19 < 0.1%
 
ValueCountFrequency (%) 
999 135 < 0.1%
 
995.6 1 < 0.1%
 
995.17 1 < 0.1%
 
994.4 1 < 0.1%
 
991.57 1 < 0.1%
 

delinq_2yrs
Real number (ℝ≥0)

ZEROS
Distinct count37
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.3068791612
Minimum0
Maximum58
Zeros1839108
Zeros (%)81.4%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2
Maximum58
Range58
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.8672303329
Coefficient of variation (CV)2.825966839
Kurtosis73.35208962
Mean0.3068791612
Median Absolute Deviation (MAD)0.4993136191
Skewness5.929811375
Sum693743
Variance0.7520884503
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1839108 81.4%
 
1 281353 12.4%
 
2 81289 3.6%
 
3 29542 1.3%
 
4 13179 0.6%
 
5 6599 0.3%
 
6 3717 0.2%
 
7 2062 0.1%
 
8 1223 0.1%
 
9 818 < 0.1%
 
Other values (27) 1749 0.1%
 
ValueCountFrequency (%) 
0 1839108 81.4%
 
1 281353 12.4%
 
2 81289 3.6%
 
3 29542 1.3%
 
4 13179 0.6%
 
ValueCountFrequency (%) 
58 1 < 0.1%
 
42 1 < 0.1%
 
39 1 < 0.1%
 
36 1 < 0.1%
 
35 1 < 0.1%
 

earliest_cr_line
Categorical

HIGH CARDINALITY
Distinct count754
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Memory size17.2 MiB
Sep-2004
 
15400
Sep-2003
 
15215
Sep-2005
 
14780
Aug-2003
 
14669
Aug-2004
 
14413
Other values (749)
2186162
ValueCountFrequency (%) 
Sep-2004 15400 0.7%
 
Sep-2003 15215 0.7%
 
Sep-2005 14780 0.7%
 
Aug-2003 14669 0.6%
 
Aug-2004 14413 0.6%
 
Aug-2001 14355 0.6%
 
Aug-2002 14322 0.6%
 
Aug-2005 14207 0.6%
 
Aug-2006 14143 0.6%
 
Oct-2003 14108 0.6%
 
Other values (744) 2115027 93.6%
 

fico_range_low
Real number (ℝ≥0)

Distinct count48
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean698.5882049
Minimum610
Maximum845
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum610
5-th percentile660
Q1675
median690
Q3715
95-th percentile765
Maximum845
Range235
Interquartile range (IQR)40

Descriptive statistics

Standard deviation33.01037645
Coefficient of variation (CV)0.04725298283
Kurtosis1.315168369
Mean698.5882049
Median Absolute Deviation (MAD)25.83583873
Skewness1.192877206
Sum1579276000
Variance1089.684954
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
660 186580 8.3%
 
670 182119 8.1%
 
665 180759 8.0%
 
680 167199 7.4%
 
675 164016 7.3%
 
685 148009 6.5%
 
690 144690 6.4%
 
695 130941 5.8%
 
700 124184 5.5%
 
705 113074 5.0%
 
Other values (38) 719097 31.8%
 
ValueCountFrequency (%) 
610 2 < 0.1%
 
615 1 < 0.1%
 
620 1 < 0.1%
 
625 2 < 0.1%
 
630 6 < 0.1%
 
ValueCountFrequency (%) 
845 441 < 0.1%
 
840 572 < 0.1%
 
835 859 < 0.1%
 
830 1439 0.1%
 
825 2189 0.1%
 

fico_range_high
Real number (ℝ≥0)

Distinct count48
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean702.5884
Minimum614
Maximum850
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum614
5-th percentile664
Q1679
median694
Q3719
95-th percentile769
Maximum850
Range236
Interquartile range (IQR)40

Descriptive statistics

Standard deviation33.01124462
Coefficient of variation (CV)0.0469851831
Kurtosis1.316769731
Mean702.5884
Median Absolute Deviation (MAD)25.83606391
Skewness1.193116484
Sum1588319113
Variance1089.742271
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
664 186580 8.3%
 
674 182119 8.1%
 
669 180759 8.0%
 
684 167199 7.4%
 
679 164016 7.3%
 
689 148009 6.5%
 
694 144690 6.4%
 
699 130941 5.8%
 
704 124184 5.5%
 
709 113074 5.0%
 
Other values (38) 719097 31.8%
 
ValueCountFrequency (%) 
614 2 < 0.1%
 
619 1 < 0.1%
 
624 1 < 0.1%
 
629 2 < 0.1%
 
634 6 < 0.1%
 
ValueCountFrequency (%) 
850 441 < 0.1%
 
844 572 < 0.1%
 
839 859 < 0.1%
 
834 1439 0.1%
 
829 2189 0.1%
 

inq_last_6mths
Real number (ℝ≥0)

ZEROS
Distinct count28
Unique (%)< 0.1%
Missing63
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.5768353889
Minimum0
Maximum33
Zeros1381722
Zeros (%)61.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile2
Maximum33
Range33
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.8859631583
Coefficient of variation (CV)1.53590292
Kurtosis9.57608952
Mean0.5768353889
Median Absolute Deviation (MAD)0.7051338138
Skewness2.066186683
Sum1304016
Variance0.784930718
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1381722 61.1%
 
1 584390 25.8%
 
2 200212 8.9%
 
3 69009 3.1%
 
4 17380 0.8%
 
5 6232 0.3%
 
6 1231 0.1%
 
7 195 < 0.1%
 
8 122 < 0.1%
 
9 50 < 0.1%
 
Other values (18) 95 < 0.1%
 
(Missing) 63 < 0.1%
 
ValueCountFrequency (%) 
0 1381722 61.1%
 
1 584390 25.8%
 
2 200212 8.9%
 
3 69009 3.1%
 
4 17380 0.8%
 
ValueCountFrequency (%) 
33 1 < 0.1%
 
32 1 < 0.1%
 
31 1 < 0.1%
 
28 1 < 0.1%
 
27 1 < 0.1%
 

mths_since_last_delinq
Real number (ℝ≥0)

MISSING
Distinct count173
Unique (%)< 0.1%
Missing1158535
Missing (%)51.2%
Infinite0
Infinite (%)0.0%
Mean34.5409158
Minimum0
Maximum226
Zeros2637
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile5
Q116
median31
Q350
95-th percentile74
Maximum226
Range226
Interquartile range (IQR)34

Descriptive statistics

Standard deviation21.9004709
Coefficient of variation (CV)0.6340443035
Kurtosis-0.6936426553
Mean34.5409158
Median Absolute Deviation (MAD)18.44887326
Skewness0.4597452469
Sum38069823
Variance479.6306255
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
12 20967 0.9%
 
13 20629 0.9%
 
6 20615 0.9%
 
9 20345 0.9%
 
7 20139 0.9%
 
14 19913 0.9%
 
8 19575 0.9%
 
15 19555 0.9%
 
10 19371 0.9%
 
18 19042 0.8%
 
Other values (163) 902015 39.9%
 
(Missing) 1158535 51.2%
 
ValueCountFrequency (%) 
0 2637 0.1%
 
1 7100 0.3%
 
2 9853 0.4%
 
3 13089 0.6%
 
4 15506 0.7%
 
ValueCountFrequency (%) 
226 1 < 0.1%
 
202 1 < 0.1%
 
195 1 < 0.1%
 
192 1 < 0.1%
 
188 2 < 0.1%
 

mths_since_last_record
Real number (ℝ≥0)

MISSING
Distinct count129
Unique (%)< 0.1%
Missing1901545
Missing (%)84.1%
Infinite0
Infinite (%)0.0%
Mean72.31284177
Minimum0
Maximum129
Zeros1296
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile24
Q155
median74
Q392
95-th percentile113
Maximum129
Range129
Interquartile range (IQR)37

Descriptive statistics

Standard deviation26.46409448
Coefficient of variation (CV)0.3659667333
Kurtosis-0.4147973573
Mean72.31284177
Median Absolute Deviation (MAD)21.5457485
Skewness-0.3692538065
Sum25971591
Variance700.3482964
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
79 5448 0.2%
 
80 5434 0.2%
 
82 5405 0.2%
 
77 5356 0.2%
 
76 5326 0.2%
 
81 5278 0.2%
 
78 5263 0.2%
 
75 5262 0.2%
 
72 5176 0.2%
 
71 5164 0.2%
 
Other values (119) 306044 13.5%
 
(Missing) 1901545 84.1%
 
ValueCountFrequency (%) 
0 1296 0.1%
 
1 162 < 0.1%
 
2 180 < 0.1%
 
3 316 < 0.1%
 
4 385 < 0.1%
 
ValueCountFrequency (%) 
129 1 < 0.1%
 
127 1 < 0.1%
 
126 4 < 0.1%
 
125 3 < 0.1%
 
124 13 < 0.1%
 

open_acc
Real number (ℝ≥0)

Distinct count91
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean11.61240207
Minimum0
Maximum101
Zeros56
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile5
Q18
median11
Q314
95-th percentile22
Maximum101
Range101
Interquartile range (IQR)6

Descriptive statistics

Standard deviation5.640861338
Coefficient of variation (CV)0.4857618006
Kurtosis3.446376782
Mean11.61240207
Median Absolute Deviation (MAD)4.295898599
Skewness1.315544951
Sum26251449
Variance31.81931664
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9 195762 8.7%
 
10 189737 8.4%
 
8 188717 8.3%
 
11 175101 7.7%
 
7 172834 7.6%
 
12 157331 7.0%
 
6 145444 6.4%
 
13 137502 6.1%
 
14 118314 5.2%
 
5 108565 4.8%
 
Other values (81) 671332 29.7%
 
ValueCountFrequency (%) 
0 56 < 0.1%
 
1 1644 0.1%
 
2 10860 0.5%
 
3 32428 1.4%
 
4 67827 3.0%
 
ValueCountFrequency (%) 
101 1 < 0.1%
 
97 1 < 0.1%
 
94 1 < 0.1%
 
93 1 < 0.1%
 
91 1 < 0.1%
 

pub_rec
Real number (ℝ≥0)

ZEROS
Distinct count43
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.1975277787
Minimum0
Maximum86
Zeros1902758
Zeros (%)84.2%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum86
Range86
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.5705150143
Coefficient of variation (CV)2.888277376
Kurtosis704.1159105
Mean0.1975277787
Median Absolute Deviation (MAD)0.3325144449
Skewness11.37680843
Sum446539
Variance0.3254873815
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1902758 84.2%
 
1 305390 13.5%
 
2 34154 1.5%
 
3 10567 0.5%
 
4 3872 0.2%
 
5 1843 0.1%
 
6 933 < 0.1%
 
7 427 < 0.1%
 
8 243 < 0.1%
 
9 143 < 0.1%
 
Other values (33) 309 < 0.1%
 
ValueCountFrequency (%) 
0 1902758 84.2%
 
1 305390 13.5%
 
2 34154 1.5%
 
3 10567 0.5%
 
4 3872 0.2%
 
ValueCountFrequency (%) 
86 1 < 0.1%
 
63 1 < 0.1%
 
61 2 < 0.1%
 
54 1 < 0.1%
 
52 1 < 0.1%
 

revol_bal
Real number (ℝ≥0)

Distinct count102251
Unique (%)4.5%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean16658.45808
Minimum0
Maximum2904836
Zeros12562
Zeros (%)0.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1572
Q15950
median11324
Q320246
95-th percentile45164
Maximum2904836
Range2904836
Interquartile range (IQR)14296

Descriptive statistics

Standard deviation22948.30503
Coefficient of variation (CV)1.377576779
Kurtosis643.1980554
Mean16658.45808
Median Absolute Deviation (MAD)11741.45075
Skewness13.23198843
Sum3.765924311e+10
Variance526624703.6
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 12562 0.6%
 
8 216 < 0.1%
 
10 170 < 0.1%
 
2 169 < 0.1%
 
5235 160 < 0.1%
 
5 160 < 0.1%
 
5849 158 < 0.1%
 
6312 158 < 0.1%
 
5265 156 < 0.1%
 
6118 156 < 0.1%
 
Other values (102241) 2246603 99.4%
 
ValueCountFrequency (%) 
0 12562 0.6%
 
1 123 < 0.1%
 
2 169 < 0.1%
 
3 151 < 0.1%
 
4 153 < 0.1%
 
ValueCountFrequency (%) 
2904836 1 < 0.1%
 
2568995 1 < 0.1%
 
2560703 1 < 0.1%
 
2559552 1 < 0.1%
 
2358150 1 < 0.1%
 

revol_util
Real number (ℝ≥0)

Distinct count1430
Unique (%)0.1%
Missing1835
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean50.33769625
Minimum0
Maximum892.3
Zeros13069
Zeros (%)0.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile9.4
Q131.5
median50.3
Q369.4
95-th percentile91
Maximum892.3
Range892.3
Interquartile range (IQR)37.9

Descriptive statistics

Standard deviation24.71307332
Coefficient of variation (CV)0.4909456563
Kurtosis-0.2226717499
Mean50.33769625
Median Absolute Deviation (MAD)20.64678604
Skewness0.01255594308
Sum113706110.6
Variance610.735993
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 13069 0.6%
 
57 4324 0.2%
 
48 4283 0.2%
 
59 4272 0.2%
 
61 4223 0.2%
 
54 4190 0.2%
 
58 4188 0.2%
 
53 4185 0.2%
 
55 4181 0.2%
 
51 4175 0.2%
 
Other values (1420) 2207776 97.7%
 
ValueCountFrequency (%) 
0 13069 0.6%
 
0.01 1 < 0.1%
 
0.03 1 < 0.1%
 
0.04 1 < 0.1%
 
0.05 1 < 0.1%
 
ValueCountFrequency (%) 
892.3 1 < 0.1%
 
366.6 1 < 0.1%
 
193 1 < 0.1%
 
191 1 < 0.1%
 
184.6 1 < 0.1%
 

total_acc
Real number (ℝ≥0)

Distinct count152
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean24.16255227
Minimum1
Maximum176
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum1
5-th percentile8
Q115
median22
Q331
95-th percentile46
Maximum176
Range175
Interquartile range (IQR)16

Descriptive statistics

Standard deviation11.98752832
Coefficient of variation (CV)0.4961201194
Kurtosis1.848815197
Mean24.16255227
Median Absolute Deviation (MAD)9.352229206
Skewness1.007455501
Sum54622808
Variance143.7008352
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20 82570 3.7%
 
19 82012 3.6%
 
18 81931 3.6%
 
17 81378 3.6%
 
21 81170 3.6%
 
16 79655 3.5%
 
22 79438 3.5%
 
23 77691 3.4%
 
15 77146 3.4%
 
24 75330 3.3%
 
Other values (142) 1462318 64.7%
 
ValueCountFrequency (%) 
1 21 < 0.1%
 
2 1333 0.1%
 
3 4244 0.2%
 
4 10456 0.5%
 
5 16398 0.7%
 
ValueCountFrequency (%) 
176 1 < 0.1%
 
173 1 < 0.1%
 
169 1 < 0.1%
 
165 1 < 0.1%
 
162 1 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
w
1535467
f
725201
ValueCountFrequency (%) 
w 1535467 67.9%
 
f 725201 32.1%
 
(Missing) 33 < 0.1%
 

out_prncp
Real number (ℝ≥0)

ZEROS
Distinct count356141
Unique (%)15.8%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean4206.891439
Minimum0
Maximum40000
Zeros1352764
Zeros (%)59.8%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q36149.94
95-th percentile21077.135
Maximum40000
Range40000
Interquartile range (IQR)6149.94

Descriptive statistics

Standard deviation7343.238522
Coefficient of variation (CV)1.745526032
Kurtosis4.027761014
Mean4206.891439
Median Absolute Deviation (MAD)5449.464357
Skewness2.072895804
Sum9510384856
Variance53923151.99
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1352764 59.8%
 
8717.99 323 < 0.1%
 
8457.66 311 < 0.1%
 
8757.61 258 < 0.1%
 
33830.65 249 < 0.1%
 
8196.01 244 < 0.1%
 
9238.49 242 < 0.1%
 
8747.25 241 < 0.1%
 
7688.11 234 < 0.1%
 
8503.85 228 < 0.1%
 
Other values (356131) 905574 40.1%
 
ValueCountFrequency (%) 
0 1352764 59.8%
 
0.01 6 < 0.1%
 
0.02 4 < 0.1%
 
0.03 2 < 0.1%
 
0.04 7 < 0.1%
 
ValueCountFrequency (%) 
40000 3 < 0.1%
 
39595.02 1 < 0.1%
 
39541.82 1 < 0.1%
 
39507.58 1 < 0.1%
 
39501.1 1 < 0.1%
 

out_prncp_inv
Real number (ℝ≥0)

ZEROS
Distinct count368481
Unique (%)16.3%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean4205.965357
Minimum0
Maximum40000
Zeros1352764
Zeros (%)59.8%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q36146.31
95-th percentile21076
Maximum40000
Range40000
Interquartile range (IQR)6146.31

Descriptive statistics

Standard deviation7342.332972
Coefficient of variation (CV)1.745695066
Kurtosis4.02985103
Mean4205.965357
Median Absolute Deviation (MAD)5448.42638
Skewness2.073302878
Sum9508291291
Variance53909853.48
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1352764 59.8%
 
8717.99 316 < 0.1%
 
8457.66 310 < 0.1%
 
8757.61 254 < 0.1%
 
8196.01 242 < 0.1%
 
9238.49 240 < 0.1%
 
8747.25 237 < 0.1%
 
33830.65 237 < 0.1%
 
7688.11 233 < 0.1%
 
8503.85 227 < 0.1%
 
Other values (368471) 905608 40.1%
 
ValueCountFrequency (%) 
0 1352764 59.8%
 
0.01 6 < 0.1%
 
0.02 4 < 0.1%
 
0.03 2 < 0.1%
 
0.04 7 < 0.1%
 
ValueCountFrequency (%) 
40000 3 < 0.1%
 
39595.02 1 < 0.1%
 
39541.82 1 < 0.1%
 
39507.58 1 < 0.1%
 
39501.1 1 < 0.1%
 

total_pymnt
Real number (ℝ≥0)

Distinct count1633857
Unique (%)72.3%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean12082.55683
Minimum0
Maximum63296.87792
Zeros949
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1362.37
Q14546.4575
median9329.72
Q316940.86937
95-th percentile32824.63251
Maximum63296.87792
Range63296.87792
Interquartile range (IQR)12394.41187

Descriptive statistics

Standard deviation9901.383185
Coefficient of variation (CV)0.8194774769
Kurtosis1.354744602
Mean12082.55683
Median Absolute Deviation (MAD)7742.558979
Skewness1.269316227
Sum2.731464958e+10
Variance98037388.98
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 949 < 0.1%
 
10838.35484 202 < 0.1%
 
11258.43637 190 < 0.1%
 
16257.52756 180 < 0.1%
 
2129.65 177 < 0.1%
 
1520.21 176 < 0.1%
 
13510.12859 166 < 0.1%
 
1572.8 154 < 0.1%
 
13006.0278 150 < 0.1%
 
2164.17 147 < 0.1%
 
Other values (1633847) 2258177 99.9%
 
ValueCountFrequency (%) 
0 949 < 0.1%
 
0.75 1 < 0.1%
 
0.8 1 < 0.1%
 
10 1 < 0.1%
 
16.58 1 < 0.1%
 
ValueCountFrequency (%) 
63296.87792 1 < 0.1%
 
62948.99096 1 < 0.1%
 
62884.79738 1 < 0.1%
 
62862.50673 1 < 0.1%
 
62837.63969 1 < 0.1%
 

total_pymnt_inv
Real number (ℝ≥0)

Distinct count1311099
Unique (%)58.0%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean12064.39465
Minimum0
Maximum63296.88
Zeros1227
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1352.57
Q14531.8
median9309.675
Q316916.705
95-th percentile32803.403
Maximum63296.88
Range63296.88
Interquartile range (IQR)12384.905

Descriptive statistics

Standard deviation9896.991745
Coefficient of variation (CV)0.8203471478
Kurtosis1.356326811
Mean12064.39465
Median Absolute Deviation (MAD)7738.491747
Skewness1.270054921
Sum2.727359093e+10
Variance97950445.6
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1227 0.1%
 
11431.12 266 < 0.1%
 
11784.23 265 < 0.1%
 
11258.44 262 < 0.1%
 
10838.35 248 < 0.1%
 
11471.31 218 < 0.1%
 
13510.13 215 < 0.1%
 
10956.78 213 < 0.1%
 
12128.02 211 < 0.1%
 
16257.53 211 < 0.1%
 
Other values (1311089) 2257332 99.9%
 
ValueCountFrequency (%) 
0 1227 0.1%
 
0.51 1 < 0.1%
 
0.54 1 < 0.1%
 
0.75 1 < 0.1%
 
0.8 1 < 0.1%
 
ValueCountFrequency (%) 
63296.88 1 < 0.1%
 
62904.03 1 < 0.1%
 
62862.51 1 < 0.1%
 
62839.88 1 < 0.1%
 
62837.64 1 < 0.1%
 

total_rec_prncp
Real number (ℝ≥0)

Distinct count486463
Unique (%)21.5%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean9505.771588
Minimum0
Maximum40000
Zeros2576
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile829.55
Q13000
median7000
Q313899.1
95-th percentile27575
Maximum40000
Range40000
Interquartile range (IQR)10899.1

Descriptive statistics

Standard deviation8321.852079
Coefficient of variation (CV)0.8754525608
Kurtosis1.117038198
Mean9505.771588
Median Absolute Deviation (MAD)6542.111611
Skewness1.256020411
Sum2.148939364e+10
Variance69253222.03
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 81386 3.6%
 
12000 59540 2.6%
 
15000 56526 2.5%
 
20000 55609 2.5%
 
5000 41118 1.8%
 
8000 39897 1.8%
 
35000 38665 1.7%
 
6000 38419 1.7%
 
16000 28831 1.3%
 
25000 27008 1.2%
 
Other values (486453) 1793669 79.3%
 
ValueCountFrequency (%) 
0 2576 0.1%
 
0.01 1 < 0.1%
 
2.13 1 < 0.1%
 
5.03 1 < 0.1%
 
5.62 1 < 0.1%
 
ValueCountFrequency (%) 
40000 5396 0.2%
 
39999.53 1 < 0.1%
 
39999.42 1 < 0.1%
 
39995.76 1 < 0.1%
 
39989.79 1 < 0.1%
 

total_rec_int
Real number (ℝ≥0)

Distinct count635921
Unique (%)28.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean2431.387654
Minimum0
Maximum28192.5
Zeros2656
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile201.82
Q1728.1875
median1525.94
Q33108.0625
95-th percentile7821.4065
Maximum28192.5
Range28192.5
Interquartile range (IQR)2379.875

Descriptive statistics

Standard deviation2679.73784
Coefficient of variation (CV)1.102143393
Kurtosis9.162197563
Mean2431.387654
Median Absolute Deviation (MAD)1851.230537
Skewness2.552499573
Sum5496560266
Variance7180994.889
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2656 0.1%
 
1431.12 315 < 0.1%
 
1784.23 309 < 0.1%
 
1258.44 272 < 0.1%
 
838.35 251 < 0.1%
 
1955.4 245 < 0.1%
 
956.78 245 < 0.1%
 
1471.31 240 < 0.1%
 
1977.77 230 < 0.1%
 
2128.02 228 < 0.1%
 
Other values (635911) 2255677 99.8%
 
ValueCountFrequency (%) 
0 2656 0.1%
 
0.01 28 < 0.1%
 
0.06 1 < 0.1%
 
0.07 2 < 0.1%
 
0.12 1 < 0.1%
 
ValueCountFrequency (%) 
28192.5 1 < 0.1%
 
27948.99 1 < 0.1%
 
27922.66 1 < 0.1%
 
27884.8 1 < 0.1%
 
27876.77 1 < 0.1%
 

total_rec_late_fee
Real number (ℝ)

SKEWED
ZEROS
Distinct count18375
Unique (%)0.8%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1.518453038
Minimum-9.5e-09
Maximum1484.34
Zeros2173513
Zeros (%)96.1%
Memory size17.2 MiB

Quantile statistics

Minimum-9.5e-09
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1484.34
Range1484.34
Interquartile range (IQR)0

Descriptive statistics

Standard deviation11.84159167
Coefficient of variation (CV)7.798457627
Kurtosis957.5469612
Mean1.518453038
Median Absolute Deviation (MAD)2.920006532
Skewness21.90352305
Sum3432718.192
Variance140.2232934
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2173513 96.1%
 
15 18145 0.8%
 
30 3738 0.2%
 
45 1296 0.1%
 
60 536 < 0.1%
 
75 253 < 0.1%
 
90 137 < 0.1%
 
16.61 133 < 0.1%
 
16.37 118 < 0.1%
 
15.94 111 < 0.1%
 
Other values (18365) 62688 2.8%
 
ValueCountFrequency (%) 
-9.5e-09 1 < 0.1%
 
-5.1e-09 1 < 0.1%
 
-3.9e-09 1 < 0.1%
 
-2e-09 1 < 0.1%
 
-1.8e-09 1 < 0.1%
 
ValueCountFrequency (%) 
1484.34 1 < 0.1%
 
1188.83 1 < 0.1%
 
1098.360001 1 < 0.1%
 
1007.36 1 < 0.1%
 
983.43 1 < 0.1%
 

recoveries
Real number (ℝ≥0)

ZEROS
Distinct count132777
Unique (%)5.9%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean143.8791352
Minimum0
Maximum39859.55
Zeros2075236
Zeros (%)91.8%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile892.543
Maximum39859.55
Range39859.55
Interquartile range (IQR)0

Descriptive statistics

Standard deviation748.1640051
Coefficient of variation (CV)5.199947887
Kurtosis196.8034342
Mean143.8791352
Median Absolute Deviation (MAD)265.5961348
Skewness10.60601568
Sum325262956.9
Variance559749.3786
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2075236 91.8%
 
50 779 < 0.1%
 
100 638 < 0.1%
 
150 594 < 0.1%
 
200 563 < 0.1%
 
300 415 < 0.1%
 
75 322 < 0.1%
 
250 289 < 0.1%
 
25 246 < 0.1%
 
125 236 < 0.1%
 
Other values (132767) 181350 8.0%
 
ValueCountFrequency (%) 
0 2075236 91.8%
 
0.01 15 < 0.1%
 
0.02 16 < 0.1%
 
0.03 25 < 0.1%
 
0.04 39 < 0.1%
 
ValueCountFrequency (%) 
39859.55 1 < 0.1%
 
39444.37 1 < 0.1%
 
37153.46 1 < 0.1%
 
36578.54 1 < 0.1%
 
35581.88 1 < 0.1%
 

collection_recovery_fee
Real number (ℝ≥0)

ZEROS
Distinct count146222
Unique (%)6.5%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean23.98256586
Minimum0
Maximum7174.719
Zeros2083655
Zeros (%)92.2%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile134.153685
Maximum7174.719
Range7174.719
Interquartile range (IQR)0

Descriptive statistics

Standard deviation131.225587
Coefficient of variation (CV)5.471707562
Kurtosis224.48381
Mean23.98256586
Median Absolute Deviation (MAD)44.4211016
Skewness11.34307972
Sum54216619.2
Variance17220.15467
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2083655 92.2%
 
9 637 < 0.1%
 
18 486 < 0.1%
 
27 455 < 0.1%
 
36 428 < 0.1%
 
54 318 < 0.1%
 
13.5 236 < 0.1%
 
45 234 < 0.1%
 
4.5 174 < 0.1%
 
22.5 171 < 0.1%
 
Other values (146212) 173874 7.7%
 
ValueCountFrequency (%) 
0 2083655 92.2%
 
0.0018 1 < 0.1%
 
0.018 1 < 0.1%
 
0.036 1 < 0.1%
 
0.0378 1 < 0.1%
 
ValueCountFrequency (%) 
7174.719 1 < 0.1%
 
7002.19 1 < 0.1%
 
6972.59 1 < 0.1%
 
6687.6228 1 < 0.1%
 
6584.1372 1 < 0.1%
 

last_pymnt_d
Categorical

HIGH CARDINALITY
Distinct count136
Unique (%)< 0.1%
Missing2460
Missing (%)0.1%
Memory size17.2 MiB
Mar-2019
853003
Feb-2019
 
97074
Aug-2018
 
39615
Jan-2019
 
38483
Mar-2018
 
38269
Other values (131)
1191797
ValueCountFrequency (%) 
Mar-2019 853003 37.7%
 
Feb-2019 97074 4.3%
 
Aug-2018 39615 1.8%
 
Jan-2019 38483 1.7%
 
Mar-2018 38269 1.7%
 
Oct-2018 37133 1.6%
 
Jul-2018 36498 1.6%
 
Nov-2018 35296 1.6%
 
Jun-2018 35168 1.6%
 
May-2018 33456 1.5%
 
Other values (126) 1014246 44.9%
 

last_pymnt_amnt
Real number (ℝ≥0)

Distinct count704467
Unique (%)31.2%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean3429.345942
Minimum0
Maximum42192.05
Zeros2893
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile100.54
Q1310.33
median600.57
Q33743.75
95-th percentile16926.714
Maximum42192.05
Range42192.05
Interquartile range (IQR)3433.42

Descriptive statistics

Standard deviation6018.247582
Coefficient of variation (CV)1.754925774
Kurtosis7.082541403
Mean3429.345942
Median Absolute Deviation (MAD)4171.947604
Skewness2.567204711
Sum7752612632
Variance36219303.96
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
50 3414 0.2%
 
0 2893 0.1%
 
100 2082 0.1%
 
332.1 1809 0.1%
 
301.15 1790 0.1%
 
361.38 1709 0.1%
 
309.74 1524 0.1%
 
320.05 1453 0.1%
 
324.65 1451 0.1%
 
304.72 1387 0.1%
 
Other values (704457) 2241156 99.1%
 
ValueCountFrequency (%) 
0 2893 0.1%
 
0.01 296 < 0.1%
 
0.02 97 < 0.1%
 
0.03 83 < 0.1%
 
0.04 79 < 0.1%
 
ValueCountFrequency (%) 
42192.05 1 < 0.1%
 
42148.53 1 < 0.1%
 
42005.2 1 < 0.1%
 
41453.07 1 < 0.1%
 
41434 1 < 0.1%
 

next_pymnt_d
Categorical

HIGH CARDINALITY
MISSING
Distinct count106
Unique (%)< 0.1%
Missing1345343
Missing (%)59.5%
Memory size17.2 MiB
Apr-2019
912221
Mar-2019
 
277
Mar-2011
 
107
May-2019
 
105
Apr-2011
 
101
Other values (101)
 
2547
ValueCountFrequency (%) 
Apr-2019 912221 40.4%
 
Mar-2019 277 < 0.1%
 
Mar-2011 107 < 0.1%
 
May-2019 105 < 0.1%
 
Apr-2011 101 < 0.1%
 
Feb-2011 91 < 0.1%
 
Jan-2011 79 < 0.1%
 
May-2011 77 < 0.1%
 
Dec-2010 71 < 0.1%
 
Jun-2011 66 < 0.1%
 
Other values (96) 2163 0.1%
 
(Missing) 1345343 59.5%
 

last_credit_pull_d
Categorical

HIGH CARDINALITY
Distinct count141
Unique (%)< 0.1%
Missing105
Missing (%)< 0.1%
Memory size17.2 MiB
Mar-2019
1371381
Feb-2019
 
76956
Jan-2019
 
63283
Jul-2018
 
54113
Oct-2016
 
50983
Other values (136)
643880
ValueCountFrequency (%) 
Mar-2019 1371381 60.7%
 
Feb-2019 76956 3.4%
 
Jan-2019 63283 2.8%
 
Jul-2018 54113 2.4%
 
Oct-2016 50983 2.3%
 
Oct-2018 47357 2.1%
 
Dec-2018 45199 2.0%
 
Aug-2018 43656 1.9%
 
Nov-2018 43632 1.9%
 
Sep-2018 33614 1.5%
 
Other values (131) 430422 19.0%
 

last_fico_range_high
Real number (ℝ≥0)

Distinct count72
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean687.6609953
Minimum0
Maximum850
Zeros235
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile539
Q1654
median699
Q3734
95-th percentile794
Maximum850
Range850
Interquartile range (IQR)80

Descriptive statistics

Standard deviation72.97043535
Coefficient of variation (CV)0.1061139658
Kurtosis0.9163633575
Mean687.6609953
Median Absolute Deviation (MAD)55.86904715
Skewness-0.7567365639
Sum1554573207
Variance5324.684435
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
694 83697 3.7%
 
699 82915 3.7%
 
709 82358 3.6%
 
704 82319 3.6%
 
714 79410 3.5%
 
684 77821 3.4%
 
719 77448 3.4%
 
689 76599 3.4%
 
724 75229 3.3%
 
679 68535 3.0%
 
Other values (62) 1474337 65.2%
 
ValueCountFrequency (%) 
0 235 < 0.1%
 
499 37091 1.6%
 
504 8133 0.4%
 
509 8836 0.4%
 
514 10139 0.4%
 
ValueCountFrequency (%) 
850 380 < 0.1%
 
844 874 < 0.1%
 
839 1708 0.1%
 
834 3459 0.2%
 
829 5614 0.2%
 

last_fico_range_low
Real number (ℝ≥0)

ZEROS
Distinct count71
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean675.5397298
Minimum0
Maximum845
Zeros37326
Zeros (%)1.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile535
Q1650
median695
Q3730
95-th percentile790
Maximum845
Range845
Interquartile range (IQR)80

Descriptive statistics

Standard deviation111.0976261
Coefficient of variation (CV)0.1644575755
Kurtosis19.99158902
Mean675.5397298
Median Absolute Deviation (MAD)65.64674938
Skewness-3.737285082
Sum1527171050
Variance12342.68254
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
690 83697 3.7%
 
695 82915 3.7%
 
705 82358 3.6%
 
700 82319 3.6%
 
710 79410 3.5%
 
680 77821 3.4%
 
715 77448 3.4%
 
685 76599 3.4%
 
720 75229 3.3%
 
675 68535 3.0%
 
Other values (61) 1474337 65.2%
 
ValueCountFrequency (%) 
0 37326 1.7%
 
500 8133 0.4%
 
505 8836 0.4%
 
510 10139 0.4%
 
515 10295 0.5%
 
ValueCountFrequency (%) 
845 380 < 0.1%
 
840 874 < 0.1%
 
835 1708 0.1%
 
830 3459 0.2%
 
825 5614 0.2%
 

collections_12_mths_ex_med
Real number (ℝ≥0)

ZEROS
Distinct count16
Unique (%)< 0.1%
Missing178
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.01814580077
Minimum0
Maximum20
Zeros2223085
Zeros (%)98.3%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum20
Range20
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.1508131422
Coefficient of variation (CV)8.311186928
Kurtosis607.1260844
Mean0.01814580077
Median Absolute Deviation (MAD)0.03569055259
Skewness14.03257434
Sum41019
Variance0.02274460386
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2223085 98.3%
 
1 34684 1.5%
 
2 2313 0.1%
 
3 271 < 0.1%
 
4 93 < 0.1%
 
5 36 < 0.1%
 
6 17 < 0.1%
 
7 7 < 0.1%
 
8 4 < 0.1%
 
9 4 < 0.1%
 
Other values (6) 9 < 0.1%
 
(Missing) 178 < 0.1%
 
ValueCountFrequency (%) 
0 2223085 98.3%
 
1 34684 1.5%
 
2 2313 0.1%
 
3 271 < 0.1%
 
4 93 < 0.1%
 
ValueCountFrequency (%) 
20 2 < 0.1%
 
16 1 < 0.1%
 
14 1 < 0.1%
 
12 2 < 0.1%
 
11 1 < 0.1%
 

mths_since_last_major_derog
Real number (ℝ≥0)

MISSING
Distinct count183
Unique (%)< 0.1%
Missing1679926
Missing (%)74.3%
Infinite0
Infinite (%)0.0%
Mean44.16422022
Minimum0
Maximum226
Zeros375
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile10
Q127
median44
Q362
95-th percentile77
Maximum226
Range226
Interquartile range (IQR)35

Descriptive statistics

Standard deviation21.53312059
Coefficient of variation (CV)0.4875693601
Kurtosis-0.5492963164
Mean44.16422022
Median Absolute Deviation (MAD)18.09903539
Skewness0.09211592216
Sum25649475
Variance463.6752825
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
45 9181 0.4%
 
43 9126 0.4%
 
42 9096 0.4%
 
44 9082 0.4%
 
46 9042 0.4%
 
48 8978 0.4%
 
40 8962 0.4%
 
41 8881 0.4%
 
47 8866 0.4%
 
38 8864 0.4%
 
Other values (173) 490697 21.7%
 
(Missing) 1679926 74.3%
 
ValueCountFrequency (%) 
0 375 < 0.1%
 
1 1338 0.1%
 
2 1575 0.1%
 
3 1968 0.1%
 
4 2632 0.1%
 
ValueCountFrequency (%) 
226 1 < 0.1%
 
202 1 < 0.1%
 
197 1 < 0.1%
 
195 1 < 0.1%
 
192 1 < 0.1%
 
Distinct count1
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
1
2260668
(Missing)
 
33
ValueCountFrequency (%) 
1 2260668 > 99.9%
 
(Missing) 33 < 0.1%
 

application_type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Individual
2139958
Joint App
 
120710
ValueCountFrequency (%) 
Individual 2139958 94.7%
 
Joint App 120710 5.3%
 
(Missing) 33 < 0.1%
 

annual_inc_joint
Real number (ℝ≥0)

MISSING
SKEWED
Distinct count17633
Unique (%)14.6%
Missing2139991
Missing (%)94.7%
Infinite0
Infinite (%)0.0%
Mean123624.6367
Minimum5693.51
Maximum7874821
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum5693.51
5-th percentile53310.093
Q183400
median110000
Q3147995
95-th percentile230975
Maximum7874821
Range7869127.49
Interquartile range (IQR)64595

Descriptive statistics

Standard deviation74161.34633
Coefficient of variation (CV)0.5998913186
Kurtosis1741.838783
Mean123624.6367
Median Absolute Deviation (MAD)44028.76448
Skewness21.7445355
Sum1.49227299e+10
Variance5499905289
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100000 2150 0.1%
 
120000 2057 0.1%
 
110000 2053 0.1%
 
90000 1874 0.1%
 
130000 1788 0.1%
 
80000 1650 0.1%
 
105000 1550 0.1%
 
140000 1529 0.1%
 
115000 1460 0.1%
 
150000 1460 0.1%
 
Other values (17623) 103139 4.6%
 
(Missing) 2139991 94.7%
 
ValueCountFrequency (%) 
5693.51 1 < 0.1%
 
9000 1 < 0.1%
 
11000 1 < 0.1%
 
12500 1 < 0.1%
 
13464 1 < 0.1%
 
ValueCountFrequency (%) 
7874821 1 < 0.1%
 
6282000 1 < 0.1%
 
5653500 1 < 0.1%
 
4200000 1 < 0.1%
 
2000000 1 < 0.1%
 

dti_joint
Real number (ℝ≥0)

MISSING
Distinct count4018
Unique (%)3.3%
Missing2139995
Missing (%)94.7%
Infinite0
Infinite (%)0.0%
Mean19.25181706
Minimum0
Maximum69.49
Zeros18
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile6.99
Q113.53
median18.84
Q324.62
95-th percentile33.0275
Maximum69.49
Range69.49
Interquartile range (IQR)11.09

Descriptive statistics

Standard deviation7.82208598
Coefficient of variation (CV)0.4063037767
Kurtosis-0.3840496448
Mean19.25181706
Median Absolute Deviation (MAD)6.366041599
Skewness0.2205511496
Sum2323809.83
Variance61.18502907
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
17.32 80 < 0.1%
 
18.1 77 < 0.1%
 
19.89 77 < 0.1%
 
22.39 77 < 0.1%
 
13.98 76 < 0.1%
 
18.96 76 < 0.1%
 
17.96 76 < 0.1%
 
20.45 75 < 0.1%
 
16.97 75 < 0.1%
 
17.02 75 < 0.1%
 
Other values (4008) 119942 5.3%
 
(Missing) 2139995 94.7%
 
ValueCountFrequency (%) 
0 18 < 0.1%
 
0.03 1 < 0.1%
 
0.11 1 < 0.1%
 
0.12 1 < 0.1%
 
0.13 2 < 0.1%
 
ValueCountFrequency (%) 
69.49 1 < 0.1%
 
63.66 1 < 0.1%
 
61.9 1 < 0.1%
 
61.28 1 < 0.1%
 
55.52 1 < 0.1%
 

verification_status_joint
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing2144971
Missing (%)94.9%
Memory size17.2 MiB
Not Verified
57403
Source Verified
34827
Verified
23500
ValueCountFrequency (%) 
Not Verified 57403 2.5%
 
Source Verified 34827 1.5%
 
Verified 23500 1.0%
 
(Missing) 2144971 94.9%
 

acc_now_delinq
Real number (ℝ≥0)

SKEWED
ZEROS
Distinct count9
Unique (%)< 0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.004147942241
Minimum0
Maximum14
Zeros2251857
Zeros (%)99.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum14
Range14
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.06961656266
Coefficient of variation (CV)16.78339731
Kurtosis1256.702032
Mean0.004147942241
Median Absolute Deviation (MAD)0.008263657109
Skewness22.90797767
Sum9377
Variance0.004846465797
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2251857 99.6%
 
1 8293 0.4%
 
2 421 < 0.1%
 
3 50 < 0.1%
 
4 11 < 0.1%
 
5 3 < 0.1%
 
6 2 < 0.1%
 
14 1 < 0.1%
 
7 1 < 0.1%
 
(Missing) 62 < 0.1%
 
ValueCountFrequency (%) 
0 2251857 99.6%
 
1 8293 0.4%
 
2 421 < 0.1%
 
3 50 < 0.1%
 
4 11 < 0.1%
 
ValueCountFrequency (%) 
14 1 < 0.1%
 
7 1 < 0.1%
 
6 2 < 0.1%
 
5 3 < 0.1%
 
4 11 < 0.1%
 

tot_coll_amt
Real number (ℝ≥0)

MISSING
SKEWED
ZEROS
Distinct count15574
Unique (%)0.7%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean232.7317389
Minimum0
Maximum9152545
Zeros1856129
Zeros (%)82.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile786
Maximum9152545
Range9152545
Interquartile range (IQR)0

Descriptive statistics

Standard deviation8518.461819
Coefficient of variation (CV)36.60206322
Kurtosis803765.2461
Mean232.7317389
Median Absolute Deviation (MAD)406.9449345
Skewness852.0101323
Sum509773739
Variance72564191.77
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1856129 82.1%
 
50 3924 0.2%
 
100 3250 0.1%
 
75 2489 0.1%
 
200 1911 0.1%
 
150 1904 0.1%
 
60 1791 0.1%
 
70 1457 0.1%
 
80 1411 0.1%
 
55 1247 0.1%
 
Other values (15564) 314879 13.9%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 1856129 82.1%
 
2 5 < 0.1%
 
3 2 < 0.1%
 
4 1 < 0.1%
 
5 2 < 0.1%
 
ValueCountFrequency (%) 
9152545 1 < 0.1%
 
6214661 1 < 0.1%
 
5252395 1 < 0.1%
 
932461 1 < 0.1%
 
848438 1 < 0.1%
 

tot_cur_bal
Real number (ℝ≥0)

MISSING
Distinct count487688
Unique (%)22.3%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean142492.1952
Minimum0
Maximum9971659
Zeros959
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile8195.55
Q129092
median79240
Q3213204
95-th percentile441856.45
Maximum9971659
Range9971659
Interquartile range (IQR)184112

Descriptive statistics

Standard deviation160692.6406
Coefficient of variation (CV)1.12772942
Kurtosis33.33453308
Mean142492.1952
Median Absolute Deviation (MAD)118534.8842
Skewness2.974725283
Sum3.121137644e+11
Variance2.582212475e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 959 < 0.1%
 
14186 41 < 0.1%
 
20275 39 < 0.1%
 
23772 39 < 0.1%
 
23442 38 < 0.1%
 
19923 38 < 0.1%
 
22831 38 < 0.1%
 
25197 38 < 0.1%
 
20317 38 < 0.1%
 
23607 38 < 0.1%
 
Other values (487678) 2189086 96.8%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 959 < 0.1%
 
1 13 < 0.1%
 
2 15 < 0.1%
 
3 19 < 0.1%
 
4 12 < 0.1%
 
ValueCountFrequency (%) 
9971659 1 < 0.1%
 
8524709 1 < 0.1%
 
8000078 1 < 0.1%
 
5752177 1 < 0.1%
 
5445012 1 < 0.1%
 

open_acc_6m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count19
Unique (%)< 0.1%
Missing866163
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean0.934419858
Minimum0
Maximum18
Zeros627966
Zeros (%)27.8%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q31
95-th percentile3
Maximum18
Range18
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.140699932
Coefficient of variation (CV)1.220757374
Kurtosis4.480970574
Mean0.934419858
Median Absolute Deviation (MAD)0.8415459465
Skewness1.681378599
Sum1303084
Variance1.301196335
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 627966 27.8%
 
1 434092 19.2%
 
2 204167 9.0%
 
3 81147 3.6%
 
4 29906 1.3%
 
5 10643 0.5%
 
6 3956 0.2%
 
7 1556 0.1%
 
8 625 < 0.1%
 
9 259 < 0.1%
 
Other values (9) 221 < 0.1%
 
(Missing) 866163 38.3%
 
ValueCountFrequency (%) 
0 627966 27.8%
 
1 434092 19.2%
 
2 204167 9.0%
 
3 81147 3.6%
 
4 29906 1.3%
 
ValueCountFrequency (%) 
18 1 < 0.1%
 
17 1 < 0.1%
 
16 2 < 0.1%
 
15 2 < 0.1%
 
14 9 < 0.1%
 

open_act_il
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count54
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean2.779406671
Minimum0
Maximum57
Zeros165848
Zeros (%)7.3%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median2
Q33
95-th percentile9
Maximum57
Range57
Interquartile range (IQR)2

Descriptive statistics

Standard deviation3.000784358
Coefficient of variation (CV)1.079649261
Kurtosis13.71859618
Mean2.779406671
Median Absolute Deviation (MAD)1.94380229
Skewness2.976152472
Sum3875991
Variance9.004706761
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 356302 15.8%
 
2 334086 14.8%
 
3 209677 9.3%
 
0 165848 7.3%
 
4 112592 5.0%
 
5 62357 2.8%
 
6 37624 1.7%
 
7 25961 1.1%
 
8 19050 0.8%
 
9 14849 0.7%
 
Other values (44) 56193 2.5%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 165848 7.3%
 
1 356302 15.8%
 
2 334086 14.8%
 
3 209677 9.3%
 
4 112592 5.0%
 
ValueCountFrequency (%) 
57 1 < 0.1%
 
56 1 < 0.1%
 
55 1 < 0.1%
 
53 1 < 0.1%
 
49 2 < 0.1%
 

open_il_12m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count19
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean0.6764314229
Minimum0
Maximum25
Zeros760254
Zeros (%)33.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile2
Maximum25
Range25
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.925635427
Coefficient of variation (CV)1.368409858
Kurtosis5.428570249
Mean0.6764314229
Median Absolute Deviation (MAD)0.737533615
Skewness1.791122671
Sum943310
Variance0.8568009438
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 760254 33.6%
 
1 418123 18.5%
 
2 152164 6.7%
 
3 44170 2.0%
 
4 13608 0.6%
 
5 4309 0.2%
 
6 1484 0.1%
 
7 219 < 0.1%
 
8 97 < 0.1%
 
9 49 < 0.1%
 
Other values (9) 62 < 0.1%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 760254 33.6%
 
1 418123 18.5%
 
2 152164 6.7%
 
3 44170 2.0%
 
4 13608 0.6%
 
ValueCountFrequency (%) 
25 1 < 0.1%
 
21 1 < 0.1%
 
20 2 < 0.1%
 
15 1 < 0.1%
 
14 1 < 0.1%
 

open_il_24m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count31
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean1.562751562
Minimum0
Maximum51
Zeros377489
Zeros (%)16.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile5
Maximum51
Range51
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.578672095
Coefficient of variation (CV)1.010187501
Kurtosis6.489226867
Mean1.562751562
Median Absolute Deviation (MAD)1.201007432
Skewness1.760411311
Sum2179318
Variance2.492205585
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 439811 19.5%
 
0 377489 16.7%
 
2 284333 12.6%
 
3 148127 6.6%
 
4 72627 3.2%
 
5 36227 1.6%
 
6 17577 0.8%
 
7 8851 0.4%
 
8 4506 0.2%
 
9 2262 0.1%
 
Other values (21) 2729 0.1%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 377489 16.7%
 
1 439811 19.5%
 
2 284333 12.6%
 
3 148127 6.6%
 
4 72627 3.2%
 
ValueCountFrequency (%) 
51 1 < 0.1%
 
39 1 < 0.1%
 
31 1 < 0.1%
 
30 1 < 0.1%
 
28 1 < 0.1%
 

mths_since_rcnt_il
Real number (ℝ≥0)

MISSING
Distinct count405
Unique (%)< 0.1%
Missing909957
Missing (%)40.3%
Infinite0
Infinite (%)0.0%
Mean21.22235672
Minimum0
Maximum511
Zeros653
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q17
median13
Q324
95-th percentile72
Maximum511
Range511
Interquartile range (IQR)17

Descriptive statistics

Standard deviation26.0491867
Coefficient of variation (CV)1.227440809
Kurtosis17.41971902
Mean21.22235672
Median Absolute Deviation (MAD)16.04888928
Skewness3.432616292
Sum28665971
Variance678.5601279
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7 61397 2.7%
 
4 60564 2.7%
 
3 58975 2.6%
 
6 57977 2.6%
 
8 57851 2.6%
 
5 57489 2.5%
 
9 53488 2.4%
 
13 51374 2.3%
 
10 51180 2.3%
 
2 50555 2.2%
 
Other values (395) 789894 34.9%
 
(Missing) 909957 40.3%
 
ValueCountFrequency (%) 
0 653 < 0.1%
 
1 27716 1.2%
 
2 50555 2.2%
 
3 58975 2.6%
 
4 60564 2.7%
 
ValueCountFrequency (%) 
511 1 < 0.1%
 
507 1 < 0.1%
 
505 1 < 0.1%
 
503 1 < 0.1%
 
488 1 < 0.1%
 

total_bal_il
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count162249
Unique (%)11.6%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean35506.64527
Minimum0
Maximum1837038
Zeros158666
Zeros (%)7.0%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q18695
median23127
Q346095
95-th percentile113501.1
Maximum1837038
Range1837038
Interquartile range (IQR)37400

Descriptive statistics

Standard deviation44097.45592
Coefficient of variation (CV)1.241949376
Kurtosis32.73888123
Mean35506.64527
Median Absolute Deviation (MAD)28455.63212
Skewness3.821058228
Sum4.951540158e+10
Variance1944585619
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 158666 7.0%
 
10000 103 < 0.1%
 
15000 95 < 0.1%
 
5000 86 < 0.1%
 
5500 77 < 0.1%
 
9500 66 < 0.1%
 
2000 65 < 0.1%
 
6000 64 < 0.1%
 
20000 64 < 0.1%
 
7000 64 < 0.1%
 
Other values (162239) 1235189 54.6%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 158666 7.0%
 
1 58 < 0.1%
 
2 12 < 0.1%
 
3 12 < 0.1%
 
4 9 < 0.1%
 
ValueCountFrequency (%) 
1837038 1 < 0.1%
 
1754743 1 < 0.1%
 
1711009 1 < 0.1%
 
1547285 1 < 0.1%
 
1466398 1 < 0.1%
 

il_util
Real number (ℝ≥0)

MISSING
Distinct count280
Unique (%)< 0.1%
Missing1068883
Missing (%)47.3%
Infinite0
Infinite (%)0.0%
Mean69.14097958
Minimum0
Maximum1000
Zeros6629
Zeros (%)0.3%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile25
Q155
median72
Q386
95-th percentile101
Maximum1000
Range1000
Interquartile range (IQR)31

Descriptive statistics

Standard deviation23.74838634
Coefficient of variation (CV)0.3434777246
Kurtosis7.081786181
Mean69.14097958
Median Absolute Deviation (MAD)18.58783069
Skewness-0.1724200621
Sum82403464
Variance563.9858538
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
78 22659 1.0%
 
75 22425 1.0%
 
81 22330 1.0%
 
83 22286 1.0%
 
72 22023 1.0%
 
77 21852 1.0%
 
80 21737 1.0%
 
82 21553 1.0%
 
74 21496 1.0%
 
79 21478 1.0%
 
Other values (270) 971979 43.0%
 
(Missing) 1068883 47.3%
 
ValueCountFrequency (%) 
0 6629 0.3%
 
1 439 < 0.1%
 
2 886 < 0.1%
 
3 1761 0.1%
 
4 1112 < 0.1%
 
ValueCountFrequency (%) 
1000 3 < 0.1%
 
558 1 < 0.1%
 
464 1 < 0.1%
 
428 1 < 0.1%
 
417 1 < 0.1%
 

open_rv_12m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count29
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean1.290133155
Minimum0
Maximum28
Zeros513716
Zeros (%)22.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile4
Maximum28
Range28
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.506826647
Coefficient of variation (CV)1.167962114
Kurtosis7.794958019
Mean1.290133155
Median Absolute Deviation (MAD)1.122732726
Skewness2.019059937
Sum1799141
Variance2.270526544
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 513716 22.7%
 
1 413897 18.3%
 
2 238188 10.5%
 
3 118920 5.3%
 
4 56137 2.5%
 
5 26685 1.2%
 
6 13085 0.6%
 
7 6466 0.3%
 
8 3218 0.1%
 
9 1778 0.1%
 
Other values (19) 2449 0.1%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 513716 22.7%
 
1 413897 18.3%
 
2 238188 10.5%
 
3 118920 5.3%
 
4 56137 2.5%
 
ValueCountFrequency (%) 
28 2 < 0.1%
 
27 1 < 0.1%
 
26 5 < 0.1%
 
25 1 < 0.1%
 
24 2 < 0.1%
 

open_rv_24m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count50
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean2.749923093
Minimum0
Maximum60
Zeros223783
Zeros (%)9.9%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median2
Q34
95-th percentile8
Maximum60
Range60
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.596910679
Coefficient of variation (CV)0.9443575663
Kurtosis8.208281738
Mean2.749923093
Median Absolute Deviation (MAD)1.91753523
Skewness1.977657369
Sum3834875
Variance6.743945077
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 297887 13.2%
 
2 267192 11.8%
 
0 223783 9.9%
 
3 200886 8.9%
 
4 139066 6.2%
 
5 92969 4.1%
 
6 60078 2.7%
 
7 39084 1.7%
 
8 24997 1.1%
 
9 16162 0.7%
 
Other values (40) 32435 1.4%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 223783 9.9%
 
1 297887 13.2%
 
2 267192 11.8%
 
3 200886 8.9%
 
4 139066 6.2%
 
ValueCountFrequency (%) 
60 1 < 0.1%
 
54 1 < 0.1%
 
53 1 < 0.1%
 
50 2 < 0.1%
 
49 1 < 0.1%
 

max_bal_bc
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count33726
Unique (%)2.4%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean5806.392905
Minimum0
Maximum1170668
Zeros35917
Zeros (%)1.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile340
Q12284
median4413
Q37598
95-th percentile16311
Maximum1170668
Range1170668
Interquartile range (IQR)5314

Descriptive statistics

Standard deviation5690.561012
Coefficient of variation (CV)0.9800509723
Kurtosis1748.219344
Mean5806.392905
Median Absolute Deviation (MAD)3780.198342
Skewness13.69539884
Sum8097241355
Variance32382484.63
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 35917 1.6%
 
8 572 < 0.1%
 
3000 533 < 0.1%
 
2000 504 < 0.1%
 
4000 447 < 0.1%
 
5000 423 < 0.1%
 
2500 383 < 0.1%
 
1900 333 < 0.1%
 
1500 333 < 0.1%
 
3500 330 < 0.1%
 
Other values (33716) 1354764 59.9%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 35917 1.6%
 
1 165 < 0.1%
 
2 218 < 0.1%
 
3 234 < 0.1%
 
4 217 < 0.1%
 
ValueCountFrequency (%) 
1170668 1 < 0.1%
 
776843 1 < 0.1%
 
571793 1 < 0.1%
 
500000 1 < 0.1%
 
457521 1 < 0.1%
 

all_util
Real number (ℝ≥0)

MISSING
Distinct count188
Unique (%)< 0.1%
Missing866381
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean57.03229531
Minimum0
Maximum239
Zeros2873
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile21
Q143
median58
Q372
95-th percentile90
Maximum239
Range239
Interquartile range (IQR)29

Descriptive statistics

Standard deviation20.9047476
Coefficient of variation (CV)0.3665422807
Kurtosis-0.07732273667
Mean57.03229531
Median Absolute Deviation (MAD)16.77994853
Skewness-0.1233140004
Sum79521270
Variance437.0084721
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
59 26677 1.2%
 
60 26674 1.2%
 
61 26475 1.2%
 
62 26330 1.2%
 
63 26295 1.2%
 
58 26105 1.2%
 
64 26010 1.2%
 
57 25934 1.1%
 
65 25763 1.1%
 
55 25429 1.1%
 
Other values (178) 1132628 50.1%
 
(Missing) 866381 38.3%
 
ValueCountFrequency (%) 
0 2873 0.1%
 
1 1720 0.1%
 
2 1594 0.1%
 
3 1676 0.1%
 
4 1706 0.1%
 
ValueCountFrequency (%) 
239 1 < 0.1%
 
211 1 < 0.1%
 
210 1 < 0.1%
 
204 1 < 0.1%
 
198 1 < 0.1%
 

total_rev_hi_lim
Real number (ℝ≥0)

MISSING
SKEWED
Distinct count34220
Unique (%)1.6%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean34573.94277
Minimum0
Maximum9999999
Zeros1366
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile6000
Q114700
median25400
Q343200
95-th percentile91100
Maximum9999999
Range9999999
Interquartile range (IQR)28500

Descriptive statistics

Standard deviation36728.49545
Coefficient of variation (CV)1.06231724
Kurtosis7520.926598
Mean34573.94277
Median Absolute Deviation (MAD)21511.705
Skewness32.55742738
Sum7.573048765e+10
Variance1348982378
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10000 7086 0.3%
 
15000 6840 0.3%
 
13000 6720 0.3%
 
12000 6657 0.3%
 
14000 6640 0.3%
 
11000 6624 0.3%
 
11500 6591 0.3%
 
16000 6535 0.3%
 
17000 6526 0.3%
 
12500 6496 0.3%
 
Other values (34210) 2123677 93.9%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 1366 0.1%
 
100 28 < 0.1%
 
200 71 < 0.1%
 
300 354 < 0.1%
 
400 113 < 0.1%
 
ValueCountFrequency (%) 
9999999 3 < 0.1%
 
2175000 1 < 0.1%
 
2087500 1 < 0.1%
 
2059200 1 < 0.1%
 
2013133 1 < 0.1%
 

inq_fi
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count33
Unique (%)< 0.1%
Missing866162
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean1.012866618
Minimum0
Maximum48
Zeros697142
Zeros (%)30.8%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q31
95-th percentile4
Maximum48
Range48
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.489455668
Coefficient of variation (CV)1.470534858
Kurtosis13.46503817
Mean1.012866618
Median Absolute Deviation (MAD)1.019179935
Skewness2.665084535
Sum1412482
Variance2.218478187
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 697142 30.8%
 
1 352169 15.6%
 
2 172982 7.7%
 
3 83887 3.7%
 
4 41460 1.8%
 
5 21374 0.9%
 
6 11043 0.5%
 
7 6059 0.3%
 
8 3423 0.2%
 
9 1946 0.1%
 
Other values (23) 3054 0.1%
 
(Missing) 866162 38.3%
 
ValueCountFrequency (%) 
0 697142 30.8%
 
1 352169 15.6%
 
2 172982 7.7%
 
3 83887 3.7%
 
4 41460 1.8%
 
ValueCountFrequency (%) 
48 1 < 0.1%
 
38 1 < 0.1%
 
32 1 < 0.1%
 
31 1 < 0.1%
 
29 1 < 0.1%
 

total_cu_tl
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count62
Unique (%)< 0.1%
Missing866163
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean1.477304312
Minimum0
Maximum111
Zeros753128
Zeros (%)33.3%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32
95-th percentile7
Maximum111
Range111
Interquartile range (IQR)2

Descriptive statistics

Standard deviation2.672991191
Coefficient of variation (CV)1.809370737
Kurtosis24.10976388
Mean1.477304312
Median Absolute Deviation (MAD)1.756942021
Skewness3.575038998
Sum2060157
Variance7.144881908
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 753128 33.3%
 
1 235619 10.4%
 
2 129673 5.7%
 
3 82042 3.6%
 
4 55090 2.4%
 
5 38010 1.7%
 
6 27101 1.2%
 
7 19362 0.9%
 
8 13953 0.6%
 
9 10143 0.4%
 
Other values (52) 30417 1.3%
 
(Missing) 866163 38.3%
 
ValueCountFrequency (%) 
0 753128 33.3%
 
1 235619 10.4%
 
2 129673 5.7%
 
3 82042 3.6%
 
4 55090 2.4%
 
ValueCountFrequency (%) 
111 1 < 0.1%
 
79 1 < 0.1%
 
77 1 < 0.1%
 
71 1 < 0.1%
 
68 3 < 0.1%
 

inq_last_12m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count48
Unique (%)< 0.1%
Missing866163
Missing (%)38.3%
Infinite0
Infinite (%)0.0%
Mean2.036667341
Minimum0
Maximum67
Zeros400090
Zeros (%)17.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile7
Maximum67
Range67
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.383117224
Coefficient of variation (CV)1.170106269
Kurtosis11.22465969
Mean2.036667341
Median Absolute Deviation (MAD)1.685648361
Skewness2.405157988
Sum2840210
Variance5.679247702
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 400090 17.7%
 
1 339411 15.0%
 
2 235736 10.4%
 
3 153565 6.8%
 
4 96535 4.3%
 
5 59861 2.6%
 
6 37765 1.7%
 
7 24088 1.1%
 
8 15619 0.7%
 
9 10201 0.5%
 
Other values (38) 21667 1.0%
 
(Missing) 866163 38.3%
 
ValueCountFrequency (%) 
0 400090 17.7%
 
1 339411 15.0%
 
2 235736 10.4%
 
3 153565 6.8%
 
4 96535 4.3%
 
ValueCountFrequency (%) 
67 1 < 0.1%
 
51 1 < 0.1%
 
49 1 < 0.1%
 
46 1 < 0.1%
 
45 1 < 0.1%
 

acc_open_past_24mths
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count57
Unique (%)< 0.1%
Missing50063
Missing (%)2.2%
Infinite0
Infinite (%)0.0%
Mean4.521655739
Minimum0
Maximum64
Zeros100270
Zeros (%)4.4%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median4
Q36
95-th percentile10
Maximum64
Range64
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.164229436
Coefficient of variation (CV)0.6997944157
Kurtosis4.374804415
Mean4.521655739
Median Absolute Deviation (MAD)2.418616678
Skewness1.402234451
Sum9995744
Variance10.01234792
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 331293 14.7%
 
4 307313 13.6%
 
2 305502 13.5%
 
5 258117 11.4%
 
1 222952 9.9%
 
6 201931 8.9%
 
7 149447 6.6%
 
8 106194 4.7%
 
0 100270 4.4%
 
9 73503 3.3%
 
Other values (47) 154116 6.8%
 
ValueCountFrequency (%) 
0 100270 4.4%
 
1 222952 9.9%
 
2 305502 13.5%
 
3 331293 14.7%
 
4 307313 13.6%
 
ValueCountFrequency (%) 
64 1 < 0.1%
 
61 1 < 0.1%
 
56 1 < 0.1%
 
55 1 < 0.1%
 
54 3 < 0.1%
 

avg_cur_bal
Real number (ℝ≥0)

MISSING
Distinct count88597
Unique (%)4.0%
Missing70379
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean13547.79751
Minimum0
Maximum958084
Zeros906
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1072
Q13080
median7335
Q318783
95-th percentile43578
Maximum958084
Range958084
Interquartile range (IQR)15703

Descriptive statistics

Standard deviation16474.07501
Coefficient of variation (CV)1.215996548
Kurtosis44.16460012
Mean13547.79751
Median Absolute Deviation (MAD)11255.94591
Skewness3.868891119
Sum2.967403894e+10
Variance271395147.4
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 906 < 0.1%
 
2442 273 < 0.1%
 
2277 271 < 0.1%
 
1971 268 < 0.1%
 
1967 267 < 0.1%
 
2522 267 < 0.1%
 
2148 266 < 0.1%
 
2025 266 < 0.1%
 
2292 265 < 0.1%
 
2831 265 < 0.1%
 
Other values (88587) 2187008 96.7%
 
(Missing) 70379 3.1%
 
ValueCountFrequency (%) 
0 906 < 0.1%
 
1 67 < 0.1%
 
2 59 < 0.1%
 
3 50 < 0.1%
 
4 38 < 0.1%
 
ValueCountFrequency (%) 
958084 1 < 0.1%
 
800008 1 < 0.1%
 
752994 1 < 0.1%
 
710392 1 < 0.1%
 
646339 1 < 0.1%
 

bc_open_to_buy
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count91500
Unique (%)4.2%
Missing74968
Missing (%)3.3%
Infinite0
Infinite (%)0.0%
Mean11394.26269
Minimum0
Maximum711140
Zeros30767
Zeros (%)1.4%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile162
Q11722
median5442
Q314187
95-th percentile42800
Maximum711140
Range711140
Interquartile range (IQR)12465

Descriptive statistics

Standard deviation16599.5344
Coefficient of variation (CV)1.456832693
Kurtosis27.09912245
Mean11394.26269
Median Absolute Deviation (MAD)10669.10129
Skewness3.737088307
Sum2.490481597e+10
Variance275544542.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 30767 1.4%
 
500 1954 0.1%
 
2000 1908 0.1%
 
1000 1709 0.1%
 
3000 1580 0.1%
 
2500 1395 0.1%
 
5000 1383 0.1%
 
1500 1300 0.1%
 
4000 1234 0.1%
 
3500 1160 0.1%
 
Other values (91490) 2141343 94.7%
 
(Missing) 74968 3.3%
 
ValueCountFrequency (%) 
0 30767 1.4%
 
1 342 < 0.1%
 
2 354 < 0.1%
 
3 358 < 0.1%
 
4 384 < 0.1%
 
ValueCountFrequency (%) 
711140 1 < 0.1%
 
605996 1 < 0.1%
 
559912 1 < 0.1%
 
507259 1 < 0.1%
 
497445 1 < 0.1%
 

bc_util
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count1494
Unique (%)0.1%
Missing76104
Missing (%)3.4%
Infinite0
Infinite (%)0.0%
Mean57.89994754
Minimum0
Maximum339.6
Zeros27885
Zeros (%)1.2%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile7.7
Q135.4
median60.2
Q383.1
95-th percentile97.8
Maximum339.6
Range339.6
Interquartile range (IQR)47.7

Descriptive statistics

Standard deviation28.58347454
Coefficient of variation (CV)0.4936701284
Kurtosis-1.001197473
Mean57.89994754
Median Absolute Deviation (MAD)24.46489581
Skewness-0.2697763948
Sum126488051.7
Variance817.0150167
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 27885 1.2%
 
98 6188 0.3%
 
97 5748 0.3%
 
99 5700 0.3%
 
96 5642 0.2%
 
95 5223 0.2%
 
94 4983 0.2%
 
93 4693 0.2%
 
92 4594 0.2%
 
91 4381 0.2%
 
Other values (1484) 2109560 93.3%
 
(Missing) 76104 3.4%
 
ValueCountFrequency (%) 
0 27885 1.2%
 
0.1 2267 0.1%
 
0.2 1959 0.1%
 
0.3 1680 0.1%
 
0.4 1440 0.1%
 
ValueCountFrequency (%) 
339.6 1 < 0.1%
 
318.2 1 < 0.1%
 
255.2 1 < 0.1%
 
252.3 1 < 0.1%
 
243.8 1 < 0.1%
 

chargeoff_within_12_mths
Real number (ℝ≥0)

ZEROS
Distinct count11
Unique (%)< 0.1%
Missing178
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.008464412881
Minimum0
Maximum10
Zeros2243339
Zeros (%)99.2%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum10
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.1048097892
Coefficient of variation (CV)12.38240509
Kurtosis598.1324648
Mean0.008464412881
Median Absolute Deviation (MAD)0.01680013654
Skewness18.12854845
Sum19134
Variance0.01098509191
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2243339 99.2%
 
1 15765 0.7%
 
2 1115 < 0.1%
 
3 186 < 0.1%
 
4 68 < 0.1%
 
5 22 < 0.1%
 
6 12 < 0.1%
 
7 8 < 0.1%
 
9 5 < 0.1%
 
8 2 < 0.1%
 
(Missing) 178 < 0.1%
 
ValueCountFrequency (%) 
0 2243339 99.2%
 
1 15765 0.7%
 
2 1115 < 0.1%
 
3 186 < 0.1%
 
4 68 < 0.1%
 
ValueCountFrequency (%) 
10 1 < 0.1%
 
9 5 < 0.1%
 
8 2 < 0.1%
 
7 8 < 0.1%
 
6 12 < 0.1%
 

delinq_amnt
Real number (ℝ≥0)

SKEWED
ZEROS
Distinct count2617
Unique (%)0.1%
Missing62
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean12.36982773
Minimum0
Maximum249925
Zeros2253465
Zeros (%)99.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum249925
Range249925
Interquartile range (IQR)0

Descriptive statistics

Standard deviation726.4647813
Coefficient of variation (CV)58.72877108
Kurtosis16006.0037
Mean12.36982773
Median Absolute Deviation (MAD)24.66194515
Skewness102.6547743
Sum27963715
Variance527751.0785
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2253465 99.7%
 
25 124 < 0.1%
 
65000 109 < 0.1%
 
30 85 < 0.1%
 
53 72 < 0.1%
 
54 69 < 0.1%
 
75 65 < 0.1%
 
50 64 < 0.1%
 
56 58 < 0.1%
 
57 56 < 0.1%
 
Other values (2607) 6472 0.3%
 
(Missing) 62 < 0.1%
 
ValueCountFrequency (%) 
0 2253465 99.7%
 
1 9 < 0.1%
 
2 10 < 0.1%
 
3 12 < 0.1%
 
4 15 < 0.1%
 
ValueCountFrequency (%) 
249925 1 < 0.1%
 
185408 1 < 0.1%
 
159177 1 < 0.1%
 
138474 1 < 0.1%
 
130778 1 < 0.1%
 

mo_sin_old_il_acct
Real number (ℝ≥0)

MISSING
Distinct count566
Unique (%)< 0.1%
Missing139104
Missing (%)6.2%
Infinite0
Infinite (%)0.0%
Mean125.7377608
Minimum0
Maximum999
Zeros16
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile31
Q196
median130
Q3154
95-th percentile213
Maximum999
Range999
Interquartile range (IQR)58

Descriptive statistics

Standard deviation53.38217542
Coefficient of variation (CV)0.4245516629
Kurtosis1.843977671
Mean125.7377608
Median Absolute Deviation (MAD)39.37270641
Skewness0.3513513484
Sum266764856
Variance2849.656652
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
130 25017 1.1%
 
129 24849 1.1%
 
128 24798 1.1%
 
132 24767 1.1%
 
127 24749 1.1%
 
133 24731 1.1%
 
125 24683 1.1%
 
126 24649 1.1%
 
134 24574 1.1%
 
131 24515 1.1%
 
Other values (556) 1874265 82.9%
 
(Missing) 139104 6.2%
 
ValueCountFrequency (%) 
0 16 < 0.1%
 
1 507 < 0.1%
 
2 1003 < 0.1%
 
3 1414 0.1%
 
4 1616 0.1%
 
ValueCountFrequency (%) 
999 2 < 0.1%
 
848 1 < 0.1%
 
827 1 < 0.1%
 
822 1 < 0.1%
 
808 1 < 0.1%
 

mo_sin_old_rev_tl_op
Real number (ℝ≥0)

MISSING
Distinct count787
Unique (%)< 0.1%
Missing70310
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean181.4915675
Minimum1
Maximum999
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum1
5-th percentile49
Q1116
median164
Q3232
95-th percentile369
Maximum999
Range998
Interquartile range (IQR)116

Descriptive statistics

Standard deviation97.11845373
Coefficient of variation (CV)0.5351127608
Kurtosis1.355518547
Mean181.4915675
Median Absolute Deviation (MAD)74.99282869
Skewness1.007808058
Sum397537496
Variance9431.994056
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
132 12536 0.6%
 
136 12528 0.6%
 
131 12386 0.5%
 
134 12317 0.5%
 
130 12299 0.5%
 
133 12278 0.5%
 
135 12235 0.5%
 
137 12132 0.5%
 
129 12116 0.5%
 
140 12112 0.5%
 
Other values (777) 2067452 91.5%
 
(Missing) 70310 3.1%
 
ValueCountFrequency (%) 
1 2 < 0.1%
 
2 6 < 0.1%
 
3 17 < 0.1%
 
4 19 < 0.1%
 
5 42 < 0.1%
 
ValueCountFrequency (%) 
999 1 < 0.1%
 
901 1 < 0.1%
 
852 1 < 0.1%
 
851 1 < 0.1%
 
842 1 < 0.1%
 

mo_sin_rcnt_rev_tl_op
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count333
Unique (%)< 0.1%
Missing70310
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean14.02408931
Minimum0
Maximum547
Zeros33747
Zeros (%)1.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q14
median8
Q317
95-th percentile46
Maximum547
Range547
Interquartile range (IQR)13

Descriptive statistics

Standard deviation17.53308255
Coefficient of variation (CV)1.250211844
Kurtosis21.96014259
Mean14.02408931
Median Absolute Deviation (MAD)11.12917037
Skewness3.592705204
Sum30718239
Variance307.4089838
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 167693 7.4%
 
3 161273 7.1%
 
4 147691 6.5%
 
1 137574 6.1%
 
5 132964 5.9%
 
6 117844 5.2%
 
7 107901 4.8%
 
8 96426 4.3%
 
9 85716 3.8%
 
10 78061 3.5%
 
Other values (323) 957248 42.3%
 
ValueCountFrequency (%) 
0 33747 1.5%
 
1 137574 6.1%
 
2 167693 7.4%
 
3 161273 7.1%
 
4 147691 6.5%
 
ValueCountFrequency (%) 
547 1 < 0.1%
 
502 1 < 0.1%
 
438 1 < 0.1%
 
406 1 < 0.1%
 
404 1 < 0.1%
 

mo_sin_rcnt_tl
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count232
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean8.297468672
Minimum0
Maximum382
Zeros34923
Zeros (%)1.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q13
median6
Q311
95-th percentile24
Maximum382
Range382
Interquartile range (IQR)8

Descriptive statistics

Standard deviation9.208556539
Coefficient of variation (CV)1.10980311
Kurtosis46.21937168
Mean8.297468672
Median Absolute Deviation (MAD)5.762951056
Skewness4.601065685
Sum18174709
Variance84.79751352
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 235575 10.4%
 
3 228153 10.1%
 
4 203278 9.0%
 
1 180626 8.0%
 
5 175501 7.8%
 
6 151978 6.7%
 
7 135550 6.0%
 
8 114936 5.1%
 
9 96422 4.3%
 
10 82385 3.6%
 
Other values (222) 585988 25.9%
 
ValueCountFrequency (%) 
0 34923 1.5%
 
1 180626 8.0%
 
2 235575 10.4%
 
3 228153 10.1%
 
4 203278 9.0%
 
ValueCountFrequency (%) 
382 1 < 0.1%
 
368 1 < 0.1%
 
353 1 < 0.1%
 
331 1 < 0.1%
 
314 1 < 0.1%
 

mort_acc
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count47
Unique (%)< 0.1%
Missing50063
Missing (%)2.2%
Infinite0
Infinite (%)0.0%
Mean1.555382202
Minimum0
Maximum94
Zeros929606
Zeros (%)41.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile5
Maximum94
Range94
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.904981017
Coefficient of variation (CV)1.224767144
Kurtosis10.50475648
Mean1.555382202
Median Absolute Deviation (MAD)1.505726207
Skewness1.789683755
Sum3438387
Variance3.628952676
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 929606 41.1%
 
1 393270 17.4%
 
2 325903 14.4%
 
3 231066 10.2%
 
4 150002 6.6%
 
5 86666 3.8%
 
6 46804 2.1%
 
7 23419 1.0%
 
8 11450 0.5%
 
9 5742 0.3%
 
Other values (37) 6710 0.3%
 
(Missing) 50063 2.2%
 
ValueCountFrequency (%) 
0 929606 41.1%
 
1 393270 17.4%
 
2 325903 14.4%
 
3 231066 10.2%
 
4 150002 6.6%
 
ValueCountFrequency (%) 
94 1 < 0.1%
 
87 1 < 0.1%
 
61 1 < 0.1%
 
52 1 < 0.1%
 
51 1 < 0.1%
 

mths_since_recent_bc
Real number (ℝ≥0)

MISSING
Distinct count546
Unique (%)< 0.1%
Missing73445
Missing (%)3.2%
Infinite0
Infinite (%)0.0%
Mean24.84485081
Minimum0
Maximum661
Zeros13450
Zeros (%)0.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q16
median14
Q330
95-th percentile89
Maximum661
Range661
Interquartile range (IQR)24

Descriptive statistics

Standard deviation32.31925269
Coefficient of variation (CV)1.300843098
Kurtosis20.67203482
Mean24.84485081
Median Absolute Deviation (MAD)20.69285337
Skewness3.507711335
Sum54342049
Variance1044.534095
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 104912 4.6%
 
2 102518 4.5%
 
4 100529 4.4%
 
5 94879 4.2%
 
6 88025 3.9%
 
7 83796 3.7%
 
8 78467 3.5%
 
9 72912 3.2%
 
1 69999 3.1%
 
10 68865 3.0%
 
Other values (536) 1322354 58.5%
 
(Missing) 73445 3.2%
 
ValueCountFrequency (%) 
0 13450 0.6%
 
1 69999 3.1%
 
2 102518 4.5%
 
3 104912 4.6%
 
4 100529 4.4%
 
ValueCountFrequency (%) 
661 1 < 0.1%
 
656 1 < 0.1%
 
640 1 < 0.1%
 
639 1 < 0.1%
 
628 1 < 0.1%
 

mths_since_recent_bc_dlq
Real number (ℝ≥0)

MISSING
Distinct count177
Unique (%)< 0.1%
Missing1741000
Missing (%)77.0%
Infinite0
Infinite (%)0.0%
Mean39.30308966
Minimum0
Maximum202
Zeros796
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile6
Q121
median37
Q357
95-th percentile77
Maximum202
Range202
Interquartile range (IQR)36

Descriptive statistics

Standard deviation22.61768864
Coefficient of variation (CV)0.575468464
Kurtosis-0.6228222102
Mean39.30308966
Median Absolute Deviation (MAD)19.00416691
Skewness0.3340775888
Sum20425855
Variance511.5598394
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
26 8060 0.4%
 
28 8027 0.4%
 
25 7934 0.4%
 
35 7933 0.4%
 
45 7906 0.3%
 
22 7903 0.3%
 
30 7895 0.3%
 
44 7887 0.3%
 
32 7883 0.3%
 
19 7875 0.3%
 
Other values (167) 440398 19.5%
 
(Missing) 1741000 77.0%
 
ValueCountFrequency (%) 
0 796 < 0.1%
 
1 2629 0.1%
 
2 2998 0.1%
 
3 4142 0.2%
 
4 4816 0.2%
 
ValueCountFrequency (%) 
202 1 < 0.1%
 
195 1 < 0.1%
 
194 1 < 0.1%
 
190 1 < 0.1%
 
189 1 < 0.1%
 

mths_since_recent_inq
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count26
Unique (%)< 0.1%
Missing295468
Missing (%)13.1%
Infinite0
Infinite (%)0.0%
Mean7.024194078
Minimum0
Maximum25
Zeros168927
Zeros (%)7.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q12
median5
Q311
95-th percentile19
Maximum25
Range25
Interquartile range (IQR)9

Descriptive statistics

Standard deviation5.965411442
Coefficient of variation (CV)0.8492663181
Kurtosis-0.03946573685
Mean7.024194078
Median Absolute Deviation (MAD)4.87231442
Skewness0.8890161004
Sum13804178
Variance35.58613367
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 212773 9.4%
 
2 173553 7.7%
 
0 168927 7.5%
 
3 157363 7.0%
 
4 143887 6.4%
 
5 127796 5.7%
 
6 114793 5.1%
 
7 108912 4.8%
 
8 96554 4.3%
 
9 85028 3.8%
 
Other values (16) 575647 25.5%
 
(Missing) 295468 13.1%
 
ValueCountFrequency (%) 
0 168927 7.5%
 
1 212773 9.4%
 
2 173553 7.7%
 
3 157363 7.0%
 
4 143887 6.4%
 
ValueCountFrequency (%) 
25 31 < 0.1%
 
24 9247 0.4%
 
23 18516 0.8%
 
22 20110 0.9%
 
21 22085 1.0%
 

mths_since_recent_revol_delinq
Real number (ℝ≥0)

MISSING
Distinct count179
Unique (%)< 0.1%
Missing1520342
Missing (%)67.3%
Infinite0
Infinite (%)0.0%
Mean35.78222322
Minimum0
Maximum202
Zeros1321
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile5
Q117
median33
Q351
95-th percentile76
Maximum202
Range202
Interquartile range (IQR)34

Descriptive statistics

Standard deviation22.30723894
Coefficient of variation (CV)0.6234167957
Kurtosis-0.486454921
Mean35.78222322
Median Absolute Deviation (MAD)18.63103426
Skewness0.4954874723
Sum26491691
Variance497.6129092
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
12 13402 0.6%
 
13 13281 0.6%
 
14 12802 0.6%
 
15 12782 0.6%
 
19 12542 0.6%
 
16 12506 0.6%
 
18 12500 0.6%
 
9 12431 0.5%
 
21 12324 0.5%
 
22 12269 0.5%
 
Other values (169) 613520 27.1%
 
(Missing) 1520342 67.3%
 
ValueCountFrequency (%) 
0 1321 0.1%
 
1 4821 0.2%
 
2 5792 0.3%
 
3 7817 0.3%
 
4 9073 0.4%
 
ValueCountFrequency (%) 
202 1 < 0.1%
 
197 1 < 0.1%
 
190 1 < 0.1%
 
188 1 < 0.1%
 
183 1 < 0.1%
 

num_accts_ever_120_pd
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count44
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean0.5002081819
Minimum0
Maximum58
Zeros1687416
Zeros (%)74.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile3
Maximum58
Range58
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.350325678
Coefficient of variation (CV)2.69952737
Kurtosis52.39404559
Mean0.5002081819
Median Absolute Deviation (MAD)0.770692451
Skewness5.434771953
Sum1095652
Variance1.823379435
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1687416 74.6%
 
1 270277 12.0%
 
2 105854 4.7%
 
3 48574 2.1%
 
4 28665 1.3%
 
5 17014 0.8%
 
6 11075 0.5%
 
7 7023 0.3%
 
8 4555 0.2%
 
9 2975 0.1%
 
Other values (34) 6964 0.3%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 1687416 74.6%
 
1 270277 12.0%
 
2 105854 4.7%
 
3 48574 2.1%
 
4 28665 1.3%
 
ValueCountFrequency (%) 
58 1 < 0.1%
 
51 1 < 0.1%
 
45 1 < 0.1%
 
42 2 < 0.1%
 
39 2 < 0.1%
 

num_actv_bc_tl
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count42
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean3.676068941
Minimum0
Maximum50
Zeros50061
Zeros (%)2.2%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q35
95-th percentile8
Maximum50
Range50
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.324646415
Coefficient of variation (CV)0.6323729105
Kurtosis4.647915181
Mean3.676068941
Median Absolute Deviation (MAD)1.756369551
Skewness1.476436002
Sum8052032
Variance5.403980957
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 458887 20.3%
 
2 442726 19.6%
 
4 357154 15.8%
 
1 256818 11.4%
 
5 240636 10.6%
 
6 152238 6.7%
 
7 91653 4.1%
 
8 55107 2.4%
 
0 50061 2.2%
 
9 33163 1.5%
 
Other values (32) 51949 2.3%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 50061 2.2%
 
1 256818 11.4%
 
2 442726 19.6%
 
3 458887 20.3%
 
4 357154 15.8%
 
ValueCountFrequency (%) 
50 1 < 0.1%
 
48 2 < 0.1%
 
47 1 < 0.1%
 
46 1 < 0.1%
 
45 1 < 0.1%
 

num_actv_rev_tl
Real number (ℝ≥0)

MISSING
Distinct count57
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean5.629467693
Minimum0
Maximum72
Zeros11439
Zeros (%)0.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q13
median5
Q37
95-th percentile12
Maximum72
Range72
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.382873759
Coefficient of variation (CV)0.6009224927
Kurtosis4.996738255
Mean5.629467693
Median Absolute Deviation (MAD)2.536280998
Skewness1.573518347
Sum12330741
Variance11.44383487
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4 333303 14.7%
 
3 308512 13.6%
 
5 303634 13.4%
 
6 248257 11.0%
 
2 213366 9.4%
 
7 191696 8.5%
 
8 141199 6.2%
 
9 102473 4.5%
 
1 84992 3.8%
 
10 72350 3.2%
 
Other values (47) 190610 8.4%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 11439 0.5%
 
1 84992 3.8%
 
2 213366 9.4%
 
3 308512 13.6%
 
4 333303 14.7%
 
ValueCountFrequency (%) 
72 1 < 0.1%
 
63 1 < 0.1%
 
60 1 < 0.1%
 
59 3 < 0.1%
 
57 2 < 0.1%
 

num_bc_sats
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count60
Unique (%)< 0.1%
Missing58623
Missing (%)2.6%
Infinite0
Infinite (%)0.0%
Mean4.774183294
Minimum0
Maximum71
Zeros23661
Zeros (%)1.0%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q13
median4
Q36
95-th percentile10
Maximum71
Range71
Interquartile range (IQR)3

Descriptive statistics

Standard deviation3.037921424
Coefficient of variation (CV)0.636322746
Kurtosis6.767222463
Mean4.774183294
Median Absolute Deviation (MAD)2.24687151
Skewness1.749103457
Sum10513124
Variance9.228966576
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 380903 16.8%
 
4 359451 15.9%
 
2 304911 13.5%
 
5 289607 12.8%
 
6 215249 9.5%
 
7 151218 6.7%
 
1 148636 6.6%
 
8 103846 4.6%
 
9 70471 3.1%
 
10 47462 2.1%
 
Other values (50) 130324 5.8%
 
(Missing) 58623 2.6%
 
ValueCountFrequency (%) 
0 23661 1.0%
 
1 148636 6.6%
 
2 304911 13.5%
 
3 380903 16.8%
 
4 359451 15.9%
 
ValueCountFrequency (%) 
71 1 < 0.1%
 
69 1 < 0.1%
 
64 1 < 0.1%
 
63 1 < 0.1%
 
61 1 < 0.1%
 

num_bc_tl
Real number (ℝ≥0)

MISSING
Distinct count76
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean7.726401941
Minimum0
Maximum86
Zeros5701
Zeros (%)0.3%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q14
median7
Q310
95-th percentile17
Maximum86
Range86
Interquartile range (IQR)6

Descriptive statistics

Standard deviation4.701430113
Coefficient of variation (CV)0.6084889382
Kurtosis3.905674874
Mean7.726401941
Median Absolute Deviation (MAD)3.576895528
Skewness1.425565032
Sum16923849
Variance22.10344511
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5 231341 10.2%
 
6 222963 9.9%
 
4 222258 9.8%
 
7 203775 9.0%
 
3 183556 8.1%
 
8 180553 8.0%
 
9 152474 6.7%
 
10 126591 5.6%
 
2 120417 5.3%
 
11 103389 4.6%
 
Other values (66) 443075 19.6%
 
ValueCountFrequency (%) 
0 5701 0.3%
 
1 48219 2.1%
 
2 120417 5.3%
 
3 183556 8.1%
 
4 222258 9.8%
 
ValueCountFrequency (%) 
86 1 < 0.1%
 
85 1 < 0.1%
 
82 1 < 0.1%
 
79 1 < 0.1%
 
77 1 < 0.1%
 

num_il_tl
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count122
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean8.413438782
Minimum0
Maximum159
Zeros68944
Zeros (%)3.0%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile1
Q13
median6
Q311
95-th percentile23
Maximum159
Range159
Interquartile range (IQR)8

Descriptive statistics

Standard deviation7.359113771
Coefficient of variation (CV)0.8746856026
Kurtosis7.841626515
Mean8.413438782
Median Absolute Deviation (MAD)5.320922867
Skewness2.103554166
Sum18428729
Variance54.15655549
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4 190600 8.4%
 
3 190128 8.4%
 
5 180396 8.0%
 
2 173360 7.7%
 
6 165370 7.3%
 
7 147949 6.5%
 
1 133227 5.9%
 
8 129276 5.7%
 
9 111342 4.9%
 
10 96604 4.3%
 
Other values (112) 672140 29.7%
 
ValueCountFrequency (%) 
0 68944 3.0%
 
1 133227 5.9%
 
2 173360 7.7%
 
3 190128 8.4%
 
4 190600 8.4%
 
ValueCountFrequency (%) 
159 1 < 0.1%
 
150 1 < 0.1%
 
140 1 < 0.1%
 
138 1 < 0.1%
 
132 1 < 0.1%
 

num_op_rev_tl
Real number (ℝ≥0)

MISSING
Distinct count81
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean8.24652254
Minimum0
Maximum91
Zeros1113
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile3
Q15
median7
Q310
95-th percentile17
Maximum91
Range91
Interquartile range (IQR)5

Descriptive statistics

Standard deviation4.683927892
Coefficient of variation (CV)0.5679882483
Kurtosis4.732174134
Mean8.24652254
Median Absolute Deviation (MAD)3.526223207
Skewness1.526702877
Sum18063117
Variance21.9391805
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
6 236912 10.5%
 
5 231071 10.2%
 
7 222688 9.9%
 
4 201987 8.9%
 
8 198673 8.8%
 
9 169770 7.5%
 
3 145954 6.5%
 
10 141418 6.3%
 
11 114837 5.1%
 
12 92236 4.1%
 
Other values (71) 434846 19.2%
 
ValueCountFrequency (%) 
0 1113 < 0.1%
 
1 18563 0.8%
 
2 77763 3.4%
 
3 145954 6.5%
 
4 201987 8.9%
 
ValueCountFrequency (%) 
91 3 < 0.1%
 
86 1 < 0.1%
 
83 1 < 0.1%
 
81 1 < 0.1%
 
79 1 < 0.1%
 

num_rev_accts
Real number (ℝ≥0)

MISSING
Distinct count117
Unique (%)< 0.1%
Missing70310
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean14.00462977
Minimum0
Maximum151
Zeros1
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile4
Q18
median12
Q318
95-th percentile29
Maximum151
Range151
Interquartile range (IQR)10

Descriptive statistics

Standard deviation8.038867538
Coefficient of variation (CV)0.5740149987
Kurtosis3.460986383
Mean14.00462977
Median Absolute Deviation (MAD)6.134676181
Skewness1.369541362
Sum30675615
Variance64.62339129
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 132715 5.9%
 
9 132157 5.8%
 
8 129674 5.7%
 
11 129189 5.7%
 
12 123608 5.5%
 
7 122058 5.4%
 
13 116460 5.2%
 
6 109695 4.9%
 
14 107620 4.8%
 
15 99544 4.4%
 
Other values (107) 987671 43.7%
 
ValueCountFrequency (%) 
0 1 < 0.1%
 
1 19 < 0.1%
 
2 21211 0.9%
 
3 44334 2.0%
 
4 69400 3.1%
 
ValueCountFrequency (%) 
151 1 < 0.1%
 
143 1 < 0.1%
 
128 1 < 0.1%
 
127 2 < 0.1%
 
119 1 < 0.1%
 

num_rev_tl_bal_gt_0
Real number (ℝ≥0)

MISSING
Distinct count50
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean5.577950887
Minimum0
Maximum65
Zeros11252
Zeros (%)0.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q13
median5
Q37
95-th percentile12
Maximum65
Range65
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.293433856
Coefficient of variation (CV)0.5904379443
Kurtosis4.173233011
Mean5.577950887
Median Absolute Deviation (MAD)2.487921238
Skewness1.470687356
Sum12217899
Variance10.84670656
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4 335837 14.9%
 
3 310629 13.7%
 
5 306205 13.5%
 
6 249901 11.1%
 
2 214144 9.5%
 
7 192557 8.5%
 
8 141264 6.2%
 
9 102127 4.5%
 
1 84778 3.8%
 
10 71574 3.2%
 
Other values (40) 181376 8.0%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 11252 0.5%
 
1 84778 3.8%
 
2 214144 9.5%
 
3 310629 13.7%
 
4 335837 14.9%
 
ValueCountFrequency (%) 
65 1 < 0.1%
 
59 2 < 0.1%
 
55 1 < 0.1%
 
47 1 < 0.1%
 
45 3 < 0.1%
 

num_sats
Real number (ℝ≥0)

MISSING
Distinct count91
Unique (%)< 0.1%
Missing58623
Missing (%)2.6%
Infinite0
Infinite (%)0.0%
Mean11.62812988
Minimum0
Maximum101
Zeros61
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile5
Q18
median11
Q314
95-th percentile22
Maximum101
Range101
Interquartile range (IQR)6

Descriptive statistics

Standard deviation5.644026548
Coefficient of variation (CV)0.4853769784
Kurtosis3.421898901
Mean11.62812988
Median Absolute Deviation (MAD)4.298550408
Skewness1.314627806
Sum25606049
Variance31.85503568
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9 190842 8.4%
 
10 185016 8.2%
 
8 183966 8.1%
 
11 170664 7.5%
 
7 168032 7.4%
 
12 153317 6.8%
 
6 141290 6.2%
 
13 133971 5.9%
 
14 115266 5.1%
 
5 105440 4.7%
 
Other values (81) 654274 28.9%
 
ValueCountFrequency (%) 
0 61 < 0.1%
 
1 1634 0.1%
 
2 10216 0.5%
 
3 30948 1.4%
 
4 65577 2.9%
 
ValueCountFrequency (%) 
101 1 < 0.1%
 
97 1 < 0.1%
 
94 1 < 0.1%
 
93 1 < 0.1%
 
91 1 < 0.1%
 

num_tl_120dpd_2m
Real number (ℝ≥0)

MISSING
SKEWED
ZEROS
Distinct count7
Unique (%)< 0.1%
Missing153690
Missing (%)6.8%
Infinite0
Infinite (%)0.0%
Mean0.0006373958181
Minimum0
Maximum7
Zeros2105738
Zeros (%)93.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.02710643324
Coefficient of variation (CV)42.52684513
Kurtosis5541.593233
Mean0.0006373958181
Median Absolute Deviation (MAD)0.001274021441
Skewness55.80984712
Sum1343
Variance0.0007347587232
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2105738 93.1%
 
1 1219 0.1%
 
2 46 < 0.1%
 
3 5 < 0.1%
 
7 1 < 0.1%
 
6 1 < 0.1%
 
4 1 < 0.1%
 
(Missing) 153690 6.8%
 
ValueCountFrequency (%) 
0 2105738 93.1%
 
1 1219 0.1%
 
2 46 < 0.1%
 
3 5 < 0.1%
 
4 1 < 0.1%
 
ValueCountFrequency (%) 
7 1 < 0.1%
 
6 1 < 0.1%
 
4 1 < 0.1%
 
3 5 < 0.1%
 
2 46 < 0.1%
 

num_tl_30dpd
Real number (ℝ≥0)

MISSING
SKEWED
ZEROS
Distinct count5
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean0.00281365162
Minimum0
Maximum4
Zeros2184561
Zeros (%)96.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.05616522447
Coefficient of variation (CV)19.96168398
Kurtosis622.4309597
Mean0.00281365162
Median Absolute Deviation (MAD)0.005612322906
Skewness22.51746312
Sum6163
Variance0.00315453244
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2184561 96.6%
 
1 5542 0.2%
 
2 253 < 0.1%
 
3 29 < 0.1%
 
4 7 < 0.1%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 2184561 96.6%
 
1 5542 0.2%
 
2 253 < 0.1%
 
3 29 < 0.1%
 
4 7 < 0.1%
 
ValueCountFrequency (%) 
4 7 < 0.1%
 
3 29 < 0.1%
 
2 253 < 0.1%
 
1 5542 0.2%
 
0 2184561 96.6%
 

num_tl_90g_dpd_24m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count34
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean0.08293766595
Minimum0
Maximum58
Zeros2073060
Zeros (%)91.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum58
Range58
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.4935732136
Coefficient of variation (CV)5.951134602
Kurtosis459.1979059
Mean0.08293766595
Median Absolute Deviation (MAD)0.1569899431
Skewness14.90157353
Sum181666
Variance0.2436145172
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2073060 91.7%
 
1 88450 3.9%
 
2 16897 0.7%
 
3 4672 0.2%
 
4 2653 0.1%
 
5 1398 0.1%
 
6 1018 < 0.1%
 
7 604 < 0.1%
 
8 467 < 0.1%
 
9 340 < 0.1%
 
Other values (24) 833 < 0.1%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 2073060 91.7%
 
1 88450 3.9%
 
2 16897 0.7%
 
3 4672 0.2%
 
4 2653 0.1%
 
ValueCountFrequency (%) 
58 1 < 0.1%
 
42 1 < 0.1%
 
39 1 < 0.1%
 
36 1 < 0.1%
 
35 1 < 0.1%
 

num_tl_op_past_12m
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count33
Unique (%)< 0.1%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean2.076755211
Minimum0
Maximum32
Zeros415975
Zeros (%)18.4%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median2
Q33
95-th percentile5
Maximum32
Range32
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.830710765
Coefficient of variation (CV)0.8815245798
Kurtosis4.69604436
Mean2.076755211
Median Absolute Deviation (MAD)1.372193814
Skewness1.503461003
Sum4548908
Variance3.351501904
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 558928 24.7%
 
2 483541 21.4%
 
0 415975 18.4%
 
3 335448 14.8%
 
4 195095 8.6%
 
5 97421 4.3%
 
6 48518 2.1%
 
7 25934 1.1%
 
8 13066 0.6%
 
9 7131 0.3%
 
Other values (23) 9335 0.4%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 415975 18.4%
 
1 558928 24.7%
 
2 483541 21.4%
 
3 335448 14.8%
 
4 195095 8.6%
 
ValueCountFrequency (%) 
32 1 < 0.1%
 
31 1 < 0.1%
 
30 2 < 0.1%
 
29 1 < 0.1%
 
28 4 < 0.1%
 

pct_tl_nvr_dlq
Real number (ℝ≥0)

MISSING
Distinct count690
Unique (%)< 0.1%
Missing70464
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean94.11457646
Minimum0
Maximum100
Zeros13
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile75
Q191.3
median100
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)8.7

Descriptive statistics

Standard deviation9.036140361
Coefficient of variation (CV)0.09601212374
Kurtosis6.854075654
Mean94.11457646
Median Absolute Deviation (MAD)6.554783662
Skewness-2.277944445
Sum206133227.6
Variance81.65183263
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100 1106209 48.9%
 
90 29542 1.3%
 
95 27840 1.2%
 
96 24023 1.1%
 
91.7 23278 1.0%
 
90.9 23274 1.0%
 
92.3 22822 1.0%
 
88.9 22667 1.0%
 
87.5 22258 1.0%
 
92.9 22101 1.0%
 
Other values (680) 866223 38.3%
 
(Missing) 70464 3.1%
 
ValueCountFrequency (%) 
0 13 < 0.1%
 
5 1 < 0.1%
 
5.9 1 < 0.1%
 
6.7 1 < 0.1%
 
7.1 2 < 0.1%
 
ValueCountFrequency (%) 
100 1106209 48.9%
 
99.4 2 < 0.1%
 
99.3 1 < 0.1%
 
99.2 9 < 0.1%
 
99.1 15 < 0.1%
 

percent_bc_gt_75
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count284
Unique (%)< 0.1%
Missing75412
Missing (%)3.3%
Infinite0
Infinite (%)0.0%
Mean42.43512654
Minimum0
Maximum100
Zeros598711
Zeros (%)26.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median37.5
Q371.4
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)71.4

Descriptive statistics

Standard deviation36.21615733
Coefficient of variation (CV)0.85344761
Kurtosis-1.25565792
Mean42.43512654
Median Absolute Deviation (MAD)31.57975337
Skewness0.3091997107
Sum92733015.24
Variance1311.610051
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 598711 26.5%
 
100 372700 16.5%
 
50 231935 10.3%
 
33.3 147284 6.5%
 
66.7 134722 6.0%
 
25 97801 4.3%
 
75 76405 3.4%
 
20 64820 2.9%
 
40 55574 2.5%
 
60 47850 2.1%
 
Other values (274) 357487 15.8%
 
(Missing) 75412 3.3%
 
ValueCountFrequency (%) 
0 598711 26.5%
 
0.14 2 < 0.1%
 
0.17 1 < 0.1%
 
0.2 10 < 0.1%
 
0.25 19 < 0.1%
 
ValueCountFrequency (%) 
100 372700 16.5%
 
95.8 1 < 0.1%
 
95.5 2 < 0.1%
 
95.2 2 < 0.1%
 
95 3 < 0.1%
 

pub_rec_bankruptcies
Real number (ℝ≥0)

ZEROS
Distinct count12
Unique (%)< 0.1%
Missing1398
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean0.1281935181
Minimum0
Maximum12
Zeros1987383
Zeros (%)87.9%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum12
Range12
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3646129975
Coefficient of variation (CV)2.844238951
Kurtosis18.65787015
Mean0.1281935181
Median Absolute Deviation (MAD)0.2255293943
Skewness3.37118635
Sum289628
Variance0.1329426379
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1987383 87.9%
 
1 258444 11.4%
 
2 10518 0.5%
 
3 2131 0.1%
 
4 541 < 0.1%
 
5 188 < 0.1%
 
6 60 < 0.1%
 
7 23 < 0.1%
 
8 10 < 0.1%
 
9 3 < 0.1%
 
Other values (2) 2 < 0.1%
 
(Missing) 1398 0.1%
 
ValueCountFrequency (%) 
0 1987383 87.9%
 
1 258444 11.4%
 
2 10518 0.5%
 
3 2131 0.1%
 
4 541 < 0.1%
 
ValueCountFrequency (%) 
12 1 < 0.1%
 
11 1 < 0.1%
 
9 3 < 0.1%
 
8 10 < 0.1%
 
7 23 < 0.1%
 

tax_liens
Real number (ℝ≥0)

SKEWED
ZEROS
Distinct count42
Unique (%)< 0.1%
Missing138
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean0.04677109198
Minimum0
Maximum85
Zeros2195933
Zeros (%)97.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum85
Range85
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.377533821
Coefficient of variation (CV)8.071947971
Kurtosis3476.326736
Mean0.04677109198
Median Absolute Deviation (MAD)0.09086779208
Skewness32.07091145
Sum105729
Variance0.142531786
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2195933 97.1%
 
1 43638 1.9%
 
2 12172 0.5%
 
3 4456 0.2%
 
4 2007 0.1%
 
5 1026 < 0.1%
 
6 557 < 0.1%
 
7 265 < 0.1%
 
8 160 < 0.1%
 
9 103 < 0.1%
 
Other values (32) 246 < 0.1%
 
(Missing) 138 < 0.1%
 
ValueCountFrequency (%) 
0 2195933 97.1%
 
1 43638 1.9%
 
2 12172 0.5%
 
3 4456 0.2%
 
4 2007 0.1%
 
ValueCountFrequency (%) 
85 1 < 0.1%
 
63 1 < 0.1%
 
61 2 < 0.1%
 
53 1 < 0.1%
 
52 1 < 0.1%
 

tot_hi_cred_lim
Real number (ℝ≥0)

MISSING
Distinct count529972
Unique (%)24.2%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean178242.7537
Minimum0
Maximum9999999
Zeros70
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile18830
Q150731
median114298.5
Q3257755
95-th percentile510883.8
Maximum9999999
Range9999999
Interquartile range (IQR)207024

Descriptive statistics

Standard deviation181574.8147
Coefficient of variation (CV)1.018693949
Kurtosis84.33085943
Mean178242.7537
Median Absolute Deviation (MAD)132475.5493
Skewness3.829997886
Sum3.904215019e+11
Variance3.296941332e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
12500 716 < 0.1%
 
15000 712 < 0.1%
 
15500 697 < 0.1%
 
19000 696 < 0.1%
 
16000 690 < 0.1%
 
16500 690 < 0.1%
 
13500 690 < 0.1%
 
11000 686 < 0.1%
 
13000 684 < 0.1%
 
14000 684 < 0.1%
 
Other values (529962) 2183447 96.6%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 70 < 0.1%
 
100 1 < 0.1%
 
119 1 < 0.1%
 
154 1 < 0.1%
 
200 16 < 0.1%
 
ValueCountFrequency (%) 
9999999 14 < 0.1%
 
9792792 1 < 0.1%
 
9375662 1 < 0.1%
 
8700253 1 < 0.1%
 
8592561 1 < 0.1%
 

total_bal_ex_mort
Real number (ℝ≥0)

MISSING
Distinct count212777
Unique (%)9.6%
Missing50063
Missing (%)2.2%
Infinite0
Infinite (%)0.0%
Mean51022.93846
Minimum0
Maximum3408095
Zeros1584
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile6556.85
Q120892
median37864
Q364350
95-th percentile138768.15
Maximum3408095
Range3408095
Interquartile range (IQR)43458

Descriptive statistics

Standard deviation49911.23567
Coefficient of variation (CV)0.9782117058
Kurtosis65.58390119
Mean51022.93846
Median Absolute Deviation (MAD)32482.7033
Skewness4.236560408
Sum1.127932466e+11
Variance2491131446
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1584 0.1%
 
23068 59 < 0.1%
 
20275 57 < 0.1%
 
24214 57 < 0.1%
 
19095 56 < 0.1%
 
20346 56 < 0.1%
 
22831 55 < 0.1%
 
25529 55 < 0.1%
 
20317 55 < 0.1%
 
25444 54 < 0.1%
 
Other values (212767) 2208550 97.7%
 
(Missing) 50063 2.2%
 
ValueCountFrequency (%) 
0 1584 0.1%
 
1 23 < 0.1%
 
2 23 < 0.1%
 
3 27 < 0.1%
 
4 14 < 0.1%
 
ValueCountFrequency (%) 
3408095 1 < 0.1%
 
2921551 1 < 0.1%
 
2698600 1 < 0.1%
 
2688920 1 < 0.1%
 
2652799 1 < 0.1%
 

total_bc_limit
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count20309
Unique (%)0.9%
Missing50063
Missing (%)2.2%
Infinite0
Infinite (%)0.0%
Mean23193.76817
Minimum0
Maximum1569000
Zeros25349
Zeros (%)1.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2300
Q18300
median16300
Q330300
95-th percentile67300
Maximum1569000
Range1569000
Interquartile range (IQR)22000

Descriptive statistics

Standard deviation23006.55824
Coefficient of variation (CV)0.9919284381
Kurtosis29.91804426
Mean23193.76817
Median Absolute Deviation (MAD)15950.66204
Skewness2.990081245
Sum5.127302529e+10
Variance529301722
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 25349 1.1%
 
5000 16941 0.7%
 
6000 15110 0.7%
 
10000 14744 0.7%
 
7000 14383 0.6%
 
8000 14055 0.6%
 
4000 13985 0.6%
 
3000 13939 0.6%
 
7500 13427 0.6%
 
9000 13175 0.6%
 
Other values (20299) 2055530 90.9%
 
(Missing) 50063 2.2%
 
ValueCountFrequency (%) 
0 25349 1.1%
 
100 17 < 0.1%
 
200 260 < 0.1%
 
250 4 < 0.1%
 
251 1 < 0.1%
 
ValueCountFrequency (%) 
1569000 1 < 0.1%
 
1105500 1 < 0.1%
 
1090700 1 < 0.1%
 
834300 1 < 0.1%
 
760000 1 < 0.1%
 

total_il_high_credit_limit
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count194137
Unique (%)8.9%
Missing70309
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean43732.01348
Minimum0
Maximum2118996
Zeros263497
Zeros (%)11.7%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q115000
median32696
Q358804.25
95-th percentile125348.45
Maximum2118996
Range2118996
Interquartile range (IQR)43804.25

Descriptive statistics

Standard deviation45072.98219
Coefficient of variation (CV)1.03066332
Kurtosis28.28428368
Mean43732.01348
Median Absolute Deviation (MAD)30898.30452
Skewness3.101032113
Sum9.579025246e+10
Variance2031573724
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 263497 11.7%
 
10000 13338 0.6%
 
15000 10273 0.5%
 
20000 8412 0.4%
 
5000 8160 0.4%
 
12000 6496 0.3%
 
25000 6200 0.3%
 
6000 5494 0.2%
 
8000 5136 0.2%
 
7000 3481 0.2%
 
Other values (194127) 1859905 82.3%
 
(Missing) 70309 3.1%
 
ValueCountFrequency (%) 
0 263497 11.7%
 
36 1 < 0.1%
 
44 1 < 0.1%
 
59 1 < 0.1%
 
75 1 < 0.1%
 
ValueCountFrequency (%) 
2118996 1 < 0.1%
 
2101913 1 < 0.1%
 
2000000 1 < 0.1%
 
1840000 1 < 0.1%
 
1736064 1 < 0.1%
 

revol_bal_joint
Real number (ℝ≥0)

MISSING
Distinct count56875
Unique (%)52.7%
Missing2152681
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean33617.27885
Minimum0
Maximum1110019
Zeros106
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile5358
Q115106.75
median26516.5
Q343769
95-th percentile85002.05
Maximum1110019
Range1110019
Interquartile range (IQR)28662.25

Descriptive statistics

Standard deviation28153.87431
Coefficient of variation (CV)0.8374822495
Kurtosis32.57097407
Mean33617.27885
Median Absolute Deviation (MAD)19663.50013
Skewness3.024207091
Sum3631338461
Variance792640638.6
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 106 < 0.1%
 
20804 10 < 0.1%
 
12149 9 < 0.1%
 
26505 9 < 0.1%
 
27424 9 < 0.1%
 
19973 9 < 0.1%
 
10041 9 < 0.1%
 
20811 9 < 0.1%
 
21072 9 < 0.1%
 
13274 9 < 0.1%
 
Other values (56865) 107832 4.8%
 
(Missing) 2152681 95.2%
 
ValueCountFrequency (%) 
0 106 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 
5 1 < 0.1%
 
ValueCountFrequency (%) 
1110019 1 < 0.1%
 
517755 1 < 0.1%
 
476826 1 < 0.1%
 
426860 1 < 0.1%
 
412216 1 < 0.1%
 

sec_app_fico_range_low
Real number (ℝ≥0)

MISSING
Distinct count62
Unique (%)0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean669.7556031
Minimum540
Maximum845
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum540
5-th percentile595
Q1645
median670
Q3695
95-th percentile745
Maximum845
Range305
Interquartile range (IQR)50

Descriptive statistics

Standard deviation44.72916274
Coefficient of variation (CV)0.0667843054
Kurtosis0.5865937386
Mean669.7556031
Median Absolute Deviation (MAD)34.09873054
Skewness0.06325630177
Sum72347670
Variance2000.698
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
670 6015 0.3%
 
665 5759 0.3%
 
660 5708 0.3%
 
675 5499 0.2%
 
680 5255 0.2%
 
655 5107 0.2%
 
650 4832 0.2%
 
690 4757 0.2%
 
685 4618 0.2%
 
695 4305 0.2%
 
Other values (52) 56166 2.5%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
540 262 < 0.1%
 
545 259 < 0.1%
 
550 300 < 0.1%
 
555 356 < 0.1%
 
560 381 < 0.1%
 
ValueCountFrequency (%) 
845 3 < 0.1%
 
840 9 < 0.1%
 
835 10 < 0.1%
 
830 24 < 0.1%
 
825 41 < 0.1%
 

sec_app_fico_range_high
Real number (ℝ≥0)

MISSING
Distinct count62
Unique (%)0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean673.7556308
Minimum544
Maximum850
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum544
5-th percentile599
Q1649
median674
Q3699
95-th percentile749
Maximum850
Range306
Interquartile range (IQR)50

Descriptive statistics

Standard deviation44.72927186
Coefficient of variation (CV)0.06638797483
Kurtosis0.586709236
Mean673.7556308
Median Absolute Deviation (MAD)34.0987572
Skewness0.06328273252
Sum72779757
Variance2000.707761
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
674 6015 0.3%
 
669 5759 0.3%
 
664 5708 0.3%
 
679 5499 0.2%
 
684 5255 0.2%
 
659 5107 0.2%
 
654 4832 0.2%
 
694 4757 0.2%
 
689 4618 0.2%
 
699 4305 0.2%
 
Other values (52) 56166 2.5%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
544 262 < 0.1%
 
549 259 < 0.1%
 
554 300 < 0.1%
 
559 356 < 0.1%
 
564 381 < 0.1%
 
ValueCountFrequency (%) 
850 3 < 0.1%
 
844 9 < 0.1%
 
839 10 < 0.1%
 
834 24 < 0.1%
 
829 41 < 0.1%
 

sec_app_earliest_cr_line
Categorical

HIGH CARDINALITY
MISSING
Distinct count663
Unique (%)0.6%
Missing2152680
Missing (%)95.2%
Memory size17.2 MiB
Aug-2006
 
998
Aug-2005
 
894
Sep-2006
 
894
Sep-2005
 
889
Sep-2004
 
848
Other values (658)
103498
ValueCountFrequency (%) 
Aug-2006 998 < 0.1%
 
Aug-2005 894 < 0.1%
 
Sep-2006 894 < 0.1%
 
Sep-2005 889 < 0.1%
 
Sep-2004 848 < 0.1%
 
Aug-2004 822 < 0.1%
 
Oct-2005 816 < 0.1%
 
Aug-2007 804 < 0.1%
 
Jul-2006 768 < 0.1%
 
Nov-2005 751 < 0.1%
 
Other values (653) 99537 4.4%
 
(Missing) 2152680 95.2%
 

sec_app_inq_last_6mths
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count7
Unique (%)< 0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean0.6332564964
Minimum0
Maximum6
Zeros65252
Zeros (%)2.9%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile3
Maximum6
Range6
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.9934011556
Coefficient of variation (CV)1.56871846
Kurtosis5.007834225
Mean0.6332564964
Median Absolute Deviation (MAD)0.7650596255
Skewness2.04610811
Sum68405
Variance0.986845856
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 65252 2.9%
 
1 26964 1.2%
 
2 9698 0.4%
 
3 3643 0.2%
 
4 1509 0.1%
 
5 650 < 0.1%
 
6 305 < 0.1%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 65252 2.9%
 
1 26964 1.2%
 
2 9698 0.4%
 
3 3643 0.2%
 
4 1509 0.1%
 
ValueCountFrequency (%) 
6 305 < 0.1%
 
5 650 < 0.1%
 
4 1509 0.1%
 
3 3643 0.2%
 
2 9698 0.4%
 

sec_app_mort_acc
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count23
Unique (%)< 0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean1.538997047
Minimum0
Maximum27
Zeros42218
Zeros (%)1.9%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile5
Maximum27
Range27
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.760568571
Coefficient of variation (CV)1.143971377
Kurtosis3.510018466
Mean1.538997047
Median Absolute Deviation (MAD)1.413264515
Skewness1.451643251
Sum166244
Variance3.099601694
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 42218 1.9%
 
1 21072 0.9%
 
2 17790 0.8%
 
3 12141 0.5%
 
4 7379 0.3%
 
5 3926 0.2%
 
6 1939 0.1%
 
7 851 < 0.1%
 
8 373 < 0.1%
 
9 165 < 0.1%
 
Other values (13) 167 < 0.1%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 42218 1.9%
 
1 21072 0.9%
 
2 17790 0.8%
 
3 12141 0.5%
 
4 7379 0.3%
 
ValueCountFrequency (%) 
27 1 < 0.1%
 
23 1 < 0.1%
 
22 1 < 0.1%
 
20 1 < 0.1%
 
18 2 < 0.1%
 

sec_app_open_acc
Real number (ℝ≥0)

MISSING
Distinct count67
Unique (%)0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean11.46945501
Minimum0
Maximum82
Zeros95
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile3
Q17
median10
Q315
95-th percentile24
Maximum82
Range82
Interquartile range (IQR)8

Descriptive statistics

Standard deviation6.627271136
Coefficient of variation (CV)0.5778191839
Kurtosis2.577122093
Mean11.46945501
Median Absolute Deviation (MAD)5.099225978
Skewness1.187173558
Sum1238942
Variance43.92072271
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9 7711 0.3%
 
8 7690 0.3%
 
7 7336 0.3%
 
10 7297 0.3%
 
11 6786 0.3%
 
6 6640 0.3%
 
12 6331 0.3%
 
5 5889 0.3%
 
13 5623 0.2%
 
14 5030 0.2%
 
Other values (57) 41688 1.8%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 95 < 0.1%
 
1 1499 0.1%
 
2 2553 0.1%
 
3 3740 0.2%
 
4 4812 0.2%
 
ValueCountFrequency (%) 
82 1 < 0.1%
 
73 1 < 0.1%
 
67 1 < 0.1%
 
66 1 < 0.1%
 
65 1 < 0.1%
 

sec_app_revol_util
Real number (ℝ≥0)

MISSING
Distinct count1216
Unique (%)1.1%
Missing2154517
Missing (%)95.3%
Infinite0
Infinite (%)0.0%
Mean58.16910081
Minimum0
Maximum434.3
Zeros1182
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile12.4
Q139.8
median60.2
Q378.6
95-th percentile95.9
Maximum434.3
Range434.3
Interquartile range (IQR)38.8

Descriptive statistics

Standard deviation25.54821161
Coefficient of variation (CV)0.4392058887
Kurtosis-0.1960062169
Mean58.16910081
Median Absolute Deviation (MAD)21.2232064
Skewness-0.2564452211
Sum6176627.8
Variance652.7111167
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1182 0.1%
 
59.4 180 < 0.1%
 
62.4 179 < 0.1%
 
67.2 174 < 0.1%
 
70.1 173 < 0.1%
 
77.9 172 < 0.1%
 
70.7 170 < 0.1%
 
73.5 170 < 0.1%
 
68.8 170 < 0.1%
 
69.8 168 < 0.1%
 
Other values (1206) 103446 4.6%
 
(Missing) 2154517 95.3%
 
ValueCountFrequency (%) 
0 1182 0.1%
 
0.1 58 < 0.1%
 
0.2 36 < 0.1%
 
0.3 42 < 0.1%
 
0.4 33 < 0.1%
 
ValueCountFrequency (%) 
434.3 1 < 0.1%
 
235.3 1 < 0.1%
 
212.6 1 < 0.1%
 
191 1 < 0.1%
 
184.2 1 < 0.1%
 

sec_app_open_act_il
Real number (ℝ≥0)

MISSING
Distinct count40
Unique (%)< 0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean3.010553503
Minimum0
Maximum43
Zeros14376
Zeros (%)0.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median2
Q34
95-th percentile9
Maximum43
Range43
Interquartile range (IQR)3

Descriptive statistics

Standard deviation3.275893064
Coefficient of variation (CV)1.088136471
Kurtosis11.81614557
Mean3.010553503
Median Absolute Deviation (MAD)2.133439053
Skewness2.800302479
Sum325203
Variance10.73147537
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 24089 1.1%
 
2 23099 1.0%
 
3 16430 0.7%
 
0 14376 0.6%
 
4 9942 0.4%
 
5 5905 0.3%
 
6 3593 0.2%
 
7 2361 0.1%
 
8 1684 0.1%
 
9 1307 0.1%
 
Other values (30) 5235 0.2%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 14376 0.6%
 
1 24089 1.1%
 
2 23099 1.0%
 
3 16430 0.7%
 
4 9942 0.4%
 
ValueCountFrequency (%) 
43 1 < 0.1%
 
39 4 < 0.1%
 
38 1 < 0.1%
 
36 1 < 0.1%
 
35 1 < 0.1%
 

sec_app_num_rev_accts
Real number (ℝ≥0)

MISSING
Distinct count86
Unique (%)0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean12.53307227
Minimum0
Maximum106
Zeros580
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile3
Q17
median11
Q317
95-th percentile28
Maximum106
Range106
Interquartile range (IQR)10

Descriptive statistics

Standard deviation8.150963551
Coefficient of variation (CV)0.650356383
Kurtosis3.823558297
Mean12.53307227
Median Absolute Deviation (MAD)6.191995033
Skewness1.429661781
Sum1353835
Variance66.43820681
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
8 6639 0.3%
 
9 6543 0.3%
 
7 6473 0.3%
 
10 6282 0.3%
 
6 6221 0.3%
 
11 5880 0.3%
 
5 5619 0.2%
 
12 5569 0.2%
 
13 5178 0.2%
 
4 4922 0.2%
 
Other values (76) 48695 2.2%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 580 < 0.1%
 
1 1741 0.1%
 
2 2730 0.1%
 
3 3822 0.2%
 
4 4922 0.2%
 
ValueCountFrequency (%) 
106 1 < 0.1%
 
96 1 < 0.1%
 
95 1 < 0.1%
 
92 1 < 0.1%
 
90 1 < 0.1%
 

sec_app_chargeoff_within_12_mths
Real number (ℝ≥0)

MISSING
SKEWED
ZEROS
Distinct count22
Unique (%)< 0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean0.0463520982
Minimum0
Maximum21
Zeros105117
Zeros (%)4.6%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum21
Range21
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.4114960112
Coefficient of variation (CV)8.877613467
Kurtosis640.9638779
Mean0.0463520982
Median Absolute Deviation (MAD)0.09021196817
Skewness20.27699345
Sum5007
Variance0.1693289673
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 105117 4.6%
 
1 2073 0.1%
 
2 429 < 0.1%
 
3 146 < 0.1%
 
4 90 < 0.1%
 
5 57 < 0.1%
 
6 30 < 0.1%
 
7 20 < 0.1%
 
10 14 < 0.1%
 
8 12 < 0.1%
 
Other values (12) 33 < 0.1%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 105117 4.6%
 
1 2073 0.1%
 
2 429 < 0.1%
 
3 146 < 0.1%
 
4 90 < 0.1%
 
ValueCountFrequency (%) 
21 2 < 0.1%
 
20 2 < 0.1%
 
19 1 < 0.1%
 
18 2 < 0.1%
 
17 2 < 0.1%
 

sec_app_collections_12_mths_ex_med
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count18
Unique (%)< 0.1%
Missing2152680
Missing (%)95.2%
Infinite0
Infinite (%)0.0%
Mean0.07756825062
Minimum0
Maximum23
Zeros101793
Zeros (%)4.5%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile1
Maximum23
Range23
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.4079956247
Coefficient of variation (CV)5.25982759
Kurtosis362.2128631
Mean0.07756825062
Median Absolute Deviation (MAD)0.1461920355
Skewness13.30092154
Sum8379
Variance0.1664604298
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 101793 4.5%
 
1 5039 0.2%
 
2 799 < 0.1%
 
3 204 < 0.1%
 
4 79 < 0.1%
 
5 31 < 0.1%
 
6 25 < 0.1%
 
8 15 < 0.1%
 
10 11 < 0.1%
 
7 7 < 0.1%
 
Other values (8) 18 < 0.1%
 
(Missing) 2152680 95.2%
 
ValueCountFrequency (%) 
0 101793 4.5%
 
1 5039 0.2%
 
2 799 < 0.1%
 
3 204 < 0.1%
 
4 79 < 0.1%
 
ValueCountFrequency (%) 
23 1 < 0.1%
 
19 1 < 0.1%
 
18 1 < 0.1%
 
16 1 < 0.1%
 
15 2 < 0.1%
 

sec_app_mths_since_last_major_derog
Real number (ℝ≥0)

MISSING
Distinct count140
Unique (%)0.4%
Missing2224759
Missing (%)98.4%
Infinite0
Infinite (%)0.0%
Mean36.93792777
Minimum0
Maximum185
Zeros399
Zeros (%)< 0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile2
Q116
median36
Q356
95-th percentile76
Maximum185
Range185
Interquartile range (IQR)40

Descriptive statistics

Standard deviation23.92458363
Coefficient of variation (CV)0.6476969629
Kurtosis-0.7008442253
Mean36.93792777
Median Absolute Deviation (MAD)20.34738778
Skewness0.28522913
Sum1327623
Variance572.385702
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 1104 < 0.1%
 
2 633 < 0.1%
 
8 575 < 0.1%
 
5 552 < 0.1%
 
13 523 < 0.1%
 
9 522 < 0.1%
 
4 509 < 0.1%
 
15 509 < 0.1%
 
43 507 < 0.1%
 
14 504 < 0.1%
 
Other values (130) 30004 1.3%
 
(Missing) 2224759 98.4%
 
ValueCountFrequency (%) 
0 399 < 0.1%
 
1 1104 < 0.1%
 
2 633 < 0.1%
 
3 484 < 0.1%
 
4 509 < 0.1%
 
ValueCountFrequency (%) 
185 1 < 0.1%
 
159 1 < 0.1%
 
153 1 < 0.1%
 
147 1 < 0.1%
 
143 1 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
N
2259836
Y
 
832
(Missing)
 
33
ValueCountFrequency (%) 
N 2259836 > 99.9%
 
Y 832 < 0.1%
 
(Missing) 33 < 0.1%
 

hardship_type
Categorical

MISSING
Distinct count1
Unique (%)< 0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
INTEREST ONLY-3 MONTHS DEFERRAL
10917
ValueCountFrequency (%) 
INTEREST ONLY-3 MONTHS DEFERRAL 10917 0.5%
 
(Missing) 2249784 99.5%
 

hardship_reason
Categorical

MISSING
Distinct count9
Unique (%)0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
NATURAL_DISASTER
2965
EXCESSIVE_OBLIGATIONS
2155
UNEMPLOYMENT
1923
INCOME_CURTAILMENT
1321
MEDICAL
1294
Other values (4)
1259
ValueCountFrequency (%) 
NATURAL_DISASTER 2965 0.1%
 
EXCESSIVE_OBLIGATIONS 2155 0.1%
 
UNEMPLOYMENT 1923 0.1%
 
INCOME_CURTAILMENT 1321 0.1%
 
MEDICAL 1294 0.1%
 
REDUCED_HOURS 662 < 0.1%
 
DIVORCE 225 < 0.1%
 
FAMILY_DEATH 214 < 0.1%
 
DISABILITY 158 < 0.1%
 
(Missing) 2249784 99.5%
 

hardship_status
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
COMPLETED
7819
BROKEN
2266
ACTIVE
 
832
ValueCountFrequency (%) 
COMPLETED 7819 0.3%
 
BROKEN 2266 0.1%
 
ACTIVE 832 < 0.1%
 
(Missing) 2249784 99.5%
 

deferral_term
Categorical

MISSING
Distinct count1
Unique (%)< 0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
3
10917
ValueCountFrequency (%) 
3 10917 0.5%
 
(Missing) 2249784 99.5%
 

hardship_amount
Real number (ℝ≥0)

MISSING
Distinct count9162
Unique (%)83.9%
Missing2249784
Missing (%)99.5%
Infinite0
Infinite (%)0.0%
Mean155.0459806
Minimum0.64
Maximum943.94
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum0.64
5-th percentile21.068
Q159.44
median119.14
Q3213.26
95-th percentile411.056
Maximum943.94
Range943.3
Interquartile range (IQR)153.82

Descriptive statistics

Standard deviation129.0405941
Coefficient of variation (CV)0.8322730688
Kurtosis3.256810044
Mean155.0459806
Median Absolute Deviation (MAD)97.86550616
Skewness1.59871819
Sum1692636.97
Variance16651.47492
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
94.59 5 < 0.1%
 
69.9 5 < 0.1%
 
53.05 5 < 0.1%
 
132.33 5 < 0.1%
 
48.56 5 < 0.1%
 
101.15 4 < 0.1%
 
150.88 4 < 0.1%
 
63.88 4 < 0.1%
 
93.95 4 < 0.1%
 
14.73 4 < 0.1%
 
Other values (9152) 10872 0.5%
 
(Missing) 2249784 99.5%
 
ValueCountFrequency (%) 
0.64 1 < 0.1%
 
1.47 1 < 0.1%
 
1.61 1 < 0.1%
 
2.02 1 < 0.1%
 
2.15 1 < 0.1%
 
ValueCountFrequency (%) 
943.94 1 < 0.1%
 
923.4 1 < 0.1%
 
893.63 1 < 0.1%
 
893.05 1 < 0.1%
 
845.22 1 < 0.1%
 

hardship_start_date
Categorical

MISSING
Distinct count27
Unique (%)0.2%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
Sep-2017
2444
Oct-2017
 
1077
Oct-2018
 
594
Nov-2017
 
466
Aug-2018
 
463
Other values (22)
5873
ValueCountFrequency (%) 
Sep-2017 2444 0.1%
 
Oct-2017 1077 < 0.1%
 
Oct-2018 594 < 0.1%
 
Nov-2017 466 < 0.1%
 
Aug-2018 463 < 0.1%
 
Jan-2019 431 < 0.1%
 
Sep-2018 422 < 0.1%
 
Nov-2018 420 < 0.1%
 
Jun-2017 400 < 0.1%
 
May-2017 373 < 0.1%
 
Other values (17) 3827 0.2%
 
(Missing) 2249784 99.5%
 

hardship_end_date
Categorical

MISSING
Distinct count28
Unique (%)0.3%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
Dec-2017
1756
Nov-2017
1325
Jan-2018
 
749
Jan-2019
 
517
Dec-2018
 
509
Other values (23)
6061
ValueCountFrequency (%) 
Dec-2017 1756 0.1%
 
Nov-2017 1325 0.1%
 
Jan-2018 749 < 0.1%
 
Jan-2019 517 < 0.1%
 
Dec-2018 509 < 0.1%
 
Mar-2019 468 < 0.1%
 
Nov-2018 413 < 0.1%
 
Feb-2018 401 < 0.1%
 
Oct-2018 397 < 0.1%
 
Oct-2017 396 < 0.1%
 
Other values (18) 3986 0.2%
 
(Missing) 2249784 99.5%
 

payment_plan_start_date
Categorical

MISSING
Distinct count27
Unique (%)0.2%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
Sep-2017
1715
Oct-2017
1629
Nov-2017
 
640
Oct-2018
 
538
Nov-2018
 
481
Other values (22)
5914
ValueCountFrequency (%) 
Sep-2017 1715 0.1%
 
Oct-2017 1629 0.1%
 
Nov-2017 640 < 0.1%
 
Oct-2018 538 < 0.1%
 
Nov-2018 481 < 0.1%
 
Aug-2018 456 < 0.1%
 
Sep-2018 416 < 0.1%
 
Dec-2017 413 < 0.1%
 
Jun-2017 394 < 0.1%
 
Feb-2019 387 < 0.1%
 
Other values (17) 3848 0.2%
 
(Missing) 2249784 99.5%
 

hardship_length
Categorical

MISSING
Distinct count1
Unique (%)< 0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
3
10917
ValueCountFrequency (%) 
3 10917 0.5%
 
(Missing) 2249784 99.5%
 

hardship_dpd
Real number (ℝ≥0)

MISSING
Distinct count34
Unique (%)0.3%
Missing2249784
Missing (%)99.5%
Infinite0
Infinite (%)0.0%
Mean13.74388568
Minimum0
Maximum37
Zeros2402
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q15
median15
Q322
95-th percentile28
Maximum37
Range37
Interquartile range (IQR)17

Descriptive statistics

Standard deviation9.671178203
Coefficient of variation (CV)0.7036713216
Kurtosis-1.298887335
Mean13.74388568
Median Absolute Deviation (MAD)8.42185485
Skewness-0.132871902
Sum150042
Variance93.53168783
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2402 0.1%
 
26 425 < 0.1%
 
23 423 < 0.1%
 
25 419 < 0.1%
 
20 394 < 0.1%
 
16 386 < 0.1%
 
11 381 < 0.1%
 
22 375 < 0.1%
 
17 372 < 0.1%
 
27 363 < 0.1%
 
Other values (24) 4977 0.2%
 
(Missing) 2249784 99.5%
 
ValueCountFrequency (%) 
0 2402 0.1%
 
1 47 < 0.1%
 
2 53 < 0.1%
 
3 67 < 0.1%
 
4 84 < 0.1%
 
ValueCountFrequency (%) 
37 1 < 0.1%
 
32 4 < 0.1%
 
31 2 < 0.1%
 
30 29 < 0.1%
 
29 268 < 0.1%
 

hardship_loan_status
Categorical

MISSING
Distinct count5
Unique (%)< 0.1%
Missing2249784
Missing (%)99.5%
Memory size17.2 MiB
Late (16-30 days)
4770
In Grace Period
2912
Current
2769
Late (31-120 days)
 
451
Issued
 
15
ValueCountFrequency (%) 
Late (16-30 days) 4770 0.2%
 
In Grace Period 2912 0.1%
 
Current 2769 0.1%
 
Late (31-120 days) 451 < 0.1%
 
Issued 15 < 0.1%
 
(Missing) 2249784 99.5%
 

orig_projected_additional_accrued_interest
Real number (ℝ≥0)

MISSING
Distinct count7487
Unique (%)86.5%
Missing2252050
Missing (%)99.6%
Infinite0
Infinite (%)0.0%
Mean454.7980892
Minimum1.92
Maximum2680.89
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum1.92
5-th percentile62.13
Q1175.23
median352.77
Q3620.175
95-th percentile1189.005
Maximum2680.89
Range2678.97
Interquartile range (IQR)444.945

Descriptive statistics

Standard deviation375.3855001
Coefficient of variation (CV)0.8253893518
Kurtosis3.248800957
Mean454.7980892
Median Absolute Deviation (MAD)284.6419129
Skewness1.588220317
Sum3934458.27
Variance140914.2737
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
283.77 5 < 0.1%
 
396.99 5 < 0.1%
 
186.9 4 < 0.1%
 
200.37 4 < 0.1%
 
209.7 4 < 0.1%
 
237.78 4 < 0.1%
 
145.68 4 < 0.1%
 
268.14 4 < 0.1%
 
163.65 4 < 0.1%
 
174 4 < 0.1%
 
Other values (7477) 8609 0.4%
 
(Missing) 2252050 99.6%
 
ValueCountFrequency (%) 
1.92 1 < 0.1%
 
4.41 1 < 0.1%
 
6.06 1 < 0.1%
 
6.45 1 < 0.1%
 
10.17 1 < 0.1%
 
ValueCountFrequency (%) 
2680.89 1 < 0.1%
 
2679.15 1 < 0.1%
 
2535.66 1 < 0.1%
 
2513.04 1 < 0.1%
 
2486.94 1 < 0.1%
 

hardship_payoff_balance_amount
Real number (ℝ≥0)

MISSING
Distinct count10893
Unique (%)99.8%
Missing2249784
Missing (%)99.5%
Infinite0
Infinite (%)0.0%
Mean11636.88394
Minimum55.73
Maximum40306.41
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum55.73
5-th percentile2183.706
Q15627
median10028.39
Q316151.89
95-th percentile26860.882
Maximum40306.41
Range40250.68
Interquartile range (IQR)10524.89

Descriptive statistics

Standard deviation7625.988281
Coefficient of variation (CV)0.6553290657
Kurtosis0.1998384506
Mean11636.88394
Median Absolute Deviation (MAD)6159.273375
Skewness0.8645866635
Sum127039862
Variance58155697.26
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10747.75 2 < 0.1%
 
9599.86 2 < 0.1%
 
8234.71 2 < 0.1%
 
8339.75 2 < 0.1%
 
8237.68 2 < 0.1%
 
9531.41 2 < 0.1%
 
2825 2 < 0.1%
 
17515.5 2 < 0.1%
 
4651.48 2 < 0.1%
 
6627.94 2 < 0.1%
 
Other values (10883) 10897 0.5%
 
(Missing) 2249784 99.5%
 
ValueCountFrequency (%) 
55.73 1 < 0.1%
 
174.15 1 < 0.1%
 
191.12 1 < 0.1%
 
193.98 1 < 0.1%
 
206.97 1 < 0.1%
 
ValueCountFrequency (%) 
40306.41 1 < 0.1%
 
40149.35 1 < 0.1%
 
39746.94 1 < 0.1%
 
39542.45 1 < 0.1%
 
38824.41 1 < 0.1%
 

hardship_last_payment_amount
Real number (ℝ≥0)

MISSING
Distinct count9045
Unique (%)82.9%
Missing2249784
Missing (%)99.5%
Infinite0
Infinite (%)0.0%
Mean193.9943208
Minimum0.01
Maximum1407.86
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum0.01
5-th percentile0.37
Q144.44
median133.16
Q3284.19
95-th percentile596.326
Maximum1407.86
Range1407.85
Interquartile range (IQR)239.75

Descriptive statistics

Standard deviation198.6294958
Coefficient of variation (CV)1.023893354
Kurtosis3.251575683
Mean193.9943208
Median Absolute Deviation (MAD)151.7030133
Skewness1.626587167
Sum2117836
Variance39453.67661
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.02 25 < 0.1%
 
0.03 25 < 0.1%
 
0.12 23 < 0.1%
 
0.11 23 < 0.1%
 
0.1 21 < 0.1%
 
0.05 21 < 0.1%
 
0.04 20 < 0.1%
 
0.09 18 < 0.1%
 
0.07 18 < 0.1%
 
0.13 17 < 0.1%
 
Other values (9035) 10706 0.5%
 
(Missing) 2249784 99.5%
 
ValueCountFrequency (%) 
0.01 16 < 0.1%
 
0.02 25 < 0.1%
 
0.03 25 < 0.1%
 
0.04 20 < 0.1%
 
0.05 21 < 0.1%
 
ValueCountFrequency (%) 
1407.86 1 < 0.1%
 
1377.17 1 < 0.1%
 
1291.21 1 < 0.1%
 
1290.59 1 < 0.1%
 
1283.9 1 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
Cash
2182546
DirectPay
 
78122
ValueCountFrequency (%) 
Cash 2182546 96.5%
 
DirectPay 78122 3.5%
 
(Missing) 33 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing33
Missing (%)< 0.1%
Memory size17.2 MiB
N
2226422
Y
 
34246
(Missing)
 
33
ValueCountFrequency (%) 
N 2226422 98.5%
 
Y 34246 1.5%
 
(Missing) 33 < 0.1%
 

debt_settlement_flag_date
Categorical

HIGH CARDINALITY
MISSING
Distinct count83
Unique (%)0.2%
Missing2226455
Missing (%)98.5%
Memory size17.2 MiB
Feb-2019
 
2606
Mar-2019
 
2528
Jan-2019
 
2524
Oct-2018
 
2324
Dec-2018
 
2252
Other values (78)
22012
ValueCountFrequency (%) 
Feb-2019 2606 0.1%
 
Mar-2019 2528 0.1%
 
Jan-2019 2524 0.1%
 
Oct-2018 2324 0.1%
 
Dec-2018 2252 0.1%
 
Nov-2018 2186 0.1%
 
Aug-2018 1978 0.1%
 
Jun-2018 1864 0.1%
 
Jul-2018 1530 0.1%
 
Sep-2018 1524 0.1%
 
Other values (73) 12930 0.6%
 
(Missing) 2226455 98.5%
 

settlement_status
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing2226455
Missing (%)98.5%
Memory size17.2 MiB
ACTIVE
14704
COMPLETE
14505
BROKEN
5037
ValueCountFrequency (%) 
ACTIVE 14704 0.7%
 
COMPLETE 14505 0.6%
 
BROKEN 5037 0.2%
 
(Missing) 2226455 98.5%
 

settlement_date
Categorical

HIGH CARDINALITY
MISSING
Distinct count90
Unique (%)0.3%
Missing2226455
Missing (%)98.5%
Memory size17.2 MiB
Jan-2019
 
1710
Oct-2018
 
1526
Feb-2019
 
1424
Mar-2018
 
1406
Sep-2018
 
1404
Other values (85)
26776
ValueCountFrequency (%) 
Jan-2019 1710 0.1%
 
Oct-2018 1526 0.1%
 
Feb-2019 1424 0.1%
 
Mar-2018 1406 0.1%
 
Sep-2018 1404 0.1%
 
Nov-2018 1397 0.1%
 
Jun-2018 1395 0.1%
 
Jan-2018 1390 0.1%
 
Aug-2018 1384 0.1%
 
May-2018 1357 0.1%
 
Other values (80) 19853 0.9%
 
(Missing) 2226455 98.5%
 

settlement_amount
Real number (ℝ≥0)

MISSING
Distinct count21941
Unique (%)64.1%
Missing2226455
Missing (%)98.5%
Infinite0
Infinite (%)0.0%
Mean5010.664267
Minimum44.21
Maximum33601
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum44.21
5-th percentile780
Q12208
median4146.11
Q36850.1725
95-th percentile12351.3025
Maximum33601
Range33556.79
Interquartile range (IQR)4642.1725

Descriptive statistics

Standard deviation3693.12259
Coefficient of variation (CV)0.7370524931
Kurtosis2.176044134
Mean5010.664267
Median Absolute Deviation (MAD)2865.788189
Skewness1.311380368
Sum171595208.5
Variance13639154.47
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5000 65 < 0.1%
 
4000 52 < 0.1%
 
6000 50 < 0.1%
 
3000 50 < 0.1%
 
10000 46 < 0.1%
 
8000 45 < 0.1%
 
7000 41 < 0.1%
 
3500 39 < 0.1%
 
6500 37 < 0.1%
 
9000 35 < 0.1%
 
Other values (21931) 33786 1.5%
 
(Missing) 2226455 98.5%
 
ValueCountFrequency (%) 
44.21 1 < 0.1%
 
60.84 1 < 0.1%
 
82.96 1 < 0.1%
 
107 1 < 0.1%
 
120 1 < 0.1%
 
ValueCountFrequency (%) 
33601 1 < 0.1%
 
30000 1 < 0.1%
 
28503 1 < 0.1%
 
28000 1 < 0.1%
 
27850 1 < 0.1%
 

settlement_percentage
Real number (ℝ≥0)

MISSING
Distinct count2070
Unique (%)6.0%
Missing2226455
Missing (%)98.5%
Infinite0
Infinite (%)0.0%
Mean47.78036501
Minimum0.2
Maximum521.35
Zeros0
Zeros (%)0.0%
Memory size17.2 MiB

Quantile statistics

Minimum0.2
5-th percentile40
Q145
median45
Q350
95-th percentile60.01
Maximum521.35
Range521.15
Interquartile range (IQR)5

Descriptive statistics

Standard deviation7.311821706
Coefficient of variation (CV)0.153029842
Kurtosis522.6570965
Mean47.78036501
Median Absolute Deviation (MAD)4.889286127
Skewness9.117278087
Sum1636286.38
Variance53.46273666
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
45 11919 0.5%
 
50 5698 0.3%
 
40 2212 0.1%
 
45.01 1679 0.1%
 
60 1310 0.1%
 
55 1143 0.1%
 
50.01 1036 < 0.1%
 
44.99 869 < 0.1%
 
65 686 < 0.1%
 
49.99 484 < 0.1%
 
Other values (2060) 7210 0.3%
 
(Missing) 2226455 98.5%
 
ValueCountFrequency (%) 
0.2 1 < 0.1%
 
0.45 1 < 0.1%
 
0.55 1 < 0.1%
 
0.65 1 < 0.1%
 
10.69 1 < 0.1%
 
ValueCountFrequency (%) 
521.35 1 < 0.1%
 
184.36 1 < 0.1%
 
166.67 1 < 0.1%
 
100 3 < 0.1%
 
98.57 1 < 0.1%
 

settlement_term
Real number (ℝ≥0)

MISSING
Distinct count40
Unique (%)0.1%
Missing2226455
Missing (%)98.5%
Infinite0
Infinite (%)0.0%
Mean13.19132161
Minimum0
Maximum181
Zeros2727
Zeros (%)0.1%
Memory size17.2 MiB

Quantile statistics

Minimum0
5-th percentile0
Q16
median14
Q318
95-th percentile24
Maximum181
Range181
Interquartile range (IQR)12

Descriptive statistics

Standard deviation8.159979582
Coefficient of variation (CV)0.6185869635
Kurtosis5.645983917
Mean13.19132161
Median Absolute Deviation (MAD)6.867344646
Skewness0.1679064306
Sum451750
Variance66.58526678
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
18 6977 0.3%
 
24 6387 0.3%
 
12 4830 0.2%
 
1 3141 0.1%
 
0 2727 0.1%
 
6 1979 0.1%
 
16 1427 0.1%
 
10 1196 0.1%
 
8 1091 < 0.1%
 
14 963 < 0.1%
 
Other values (30) 3528 0.2%
 
(Missing) 2226455 98.5%
 
ValueCountFrequency (%) 
0 2727 0.1%
 
1 3141 0.1%
 
2 282 < 0.1%
 
3 247 < 0.1%
 
4 533 < 0.1%
 
ValueCountFrequency (%) 
181 1 < 0.1%
 
118 1 < 0.1%
 
112 1 < 0.1%
 
65 3 < 0.1%
 
60 1 < 0.1%
 

Sample

First rows

idmember_idloan_amntfunded_amntfunded_amnt_invtermint_rateinstallmentgradesub_gradeemp_titleemp_lengthhome_ownershipannual_incverification_statusissue_dloan_statuspymnt_planurldescpurposetitlezip_codeaddr_statedtidelinq_2yrsearliest_cr_linefico_range_lowfico_range_highinq_last_6mthsmths_since_last_delinqmths_since_last_recordopen_accpub_recrevol_balrevol_utiltotal_accinitial_list_statusout_prncpout_prncp_invtotal_pymnttotal_pymnt_invtotal_rec_prncptotal_rec_inttotal_rec_late_feerecoveriescollection_recovery_feelast_pymnt_dlast_pymnt_amntnext_pymnt_dlast_credit_pull_dlast_fico_range_highlast_fico_range_lowcollections_12_mths_ex_medmths_since_last_major_derogpolicy_codeapplication_typeannual_inc_jointdti_jointverification_status_jointacc_now_delinqtot_coll_amttot_cur_balopen_acc_6mopen_act_ilopen_il_12mopen_il_24mmths_since_rcnt_iltotal_bal_ilil_utilopen_rv_12mopen_rv_24mmax_bal_bcall_utiltotal_rev_hi_liminq_fitotal_cu_tlinq_last_12macc_open_past_24mthsavg_cur_balbc_open_to_buybc_utilchargeoff_within_12_mthsdelinq_amntmo_sin_old_il_acctmo_sin_old_rev_tl_opmo_sin_rcnt_rev_tl_opmo_sin_rcnt_tlmort_accmths_since_recent_bcmths_since_recent_bc_dlqmths_since_recent_inqmths_since_recent_revol_delinqnum_accts_ever_120_pdnum_actv_bc_tlnum_actv_rev_tlnum_bc_satsnum_bc_tlnum_il_tlnum_op_rev_tlnum_rev_acctsnum_rev_tl_bal_gt_0num_satsnum_tl_120dpd_2mnum_tl_30dpdnum_tl_90g_dpd_24mnum_tl_op_past_12mpct_tl_nvr_dlqpercent_bc_gt_75pub_rec_bankruptciestax_lienstot_hi_cred_limtotal_bal_ex_morttotal_bc_limittotal_il_high_credit_limitrevol_bal_jointsec_app_fico_range_lowsec_app_fico_range_highsec_app_earliest_cr_linesec_app_inq_last_6mthssec_app_mort_accsec_app_open_accsec_app_revol_utilsec_app_open_act_ilsec_app_num_rev_acctssec_app_chargeoff_within_12_mthssec_app_collections_12_mths_ex_medsec_app_mths_since_last_major_deroghardship_flaghardship_typehardship_reasonhardship_statusdeferral_termhardship_amounthardship_start_datehardship_end_datepayment_plan_start_datehardship_lengthhardship_dpdhardship_loan_statusorig_projected_additional_accrued_interesthardship_payoff_balance_amounthardship_last_payment_amountdisbursement_methoddebt_settlement_flagdebt_settlement_flag_datesettlement_statussettlement_datesettlement_amountsettlement_percentagesettlement_term
068407277NaN3600.03600.03600.036 months13.99123.03CC4leadman10+ yearsMORTGAGE55000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68407277NaNdebt_consolidationDebt consolidation190xxPA5.910.0Aug-2003675.0679.01.030.0NaN7.00.02765.029.713.0w0.000.004421.7239174421.723600.00821.720.00.00.0Jan-2019122.67NaNMar-2019564.0560.00.030.01.0IndividualNaNNaNNaN0.0722.0144904.02.02.00.01.021.04981.036.03.03.0722.034.09300.03.01.04.04.020701.01506.037.20.00.0148.0128.03.03.01.04.069.04.069.02.02.04.02.05.03.04.09.04.07.00.00.00.03.076.90.00.00.0178050.07746.02400.013734.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
168355089NaN24700.024700.024700.036 months11.99820.28CC1Engineer10+ yearsMORTGAGE65000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68355089NaNsmall_businessBusiness577xxSD16.061.0Dec-1999715.0719.04.06.0NaN22.00.021470.019.238.0w0.000.0025679.66000025679.6624700.00979.660.00.00.0Jun-2016926.35NaNMar-2019699.0695.00.0NaN1.0IndividualNaNNaNNaN0.00.0204396.01.01.00.01.019.018005.073.02.03.06472.029.0111800.00.00.06.04.09733.057830.027.10.00.0113.0192.02.02.04.02.0NaN0.06.00.05.05.013.017.06.020.027.05.022.00.00.00.02.097.47.70.00.0314017.039475.079300.024667.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
268341763NaN20000.020000.020000.060 months10.78432.66BB4truck driver10+ yearsMORTGAGE63000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68341763NaNhome_improvementNaN605xxIL10.780.0Aug-2000695.0699.00.0NaNNaN6.00.07869.056.218.0w0.000.0022705.92429422705.9220000.002705.920.00.00.0Jun-201715813.30NaNMar-2019704.0700.00.0NaN1.0Joint App71000.013.85Not Verified0.00.0189699.00.01.00.04.019.010827.073.00.02.02081.065.014000.02.05.01.06.031617.02737.055.90.00.0125.0184.014.014.05.0101.0NaN10.0NaN0.02.03.02.04.06.04.07.03.06.00.00.00.00.0100.050.00.00.0218418.018696.06200.014877.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
366310712NaN35000.035000.035000.060 months14.85829.90CC5Information Systems Officer10+ yearsMORTGAGE110000.0Source VerifiedDec-2015Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=66310712NaNdebt_consolidationDebt consolidation076xxNJ17.060.0Sep-2008785.0789.00.0NaNNaN13.00.07802.011.617.0w15897.6515897.6531464.01000031464.0119102.3512361.660.00.00.0Feb-2019829.90Apr-2019Mar-2019679.0675.00.0NaN1.0IndividualNaNNaNNaN0.00.0301500.01.01.00.01.023.012609.070.01.01.06987.045.067300.00.01.00.02.023192.054962.012.10.00.036.087.02.02.01.02.0NaNNaNNaN0.04.05.08.010.02.010.013.05.013.00.00.00.01.0100.00.00.00.0381215.052226.062500.018000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
468476807NaN10400.010400.010400.060 months22.45289.91FF1Contract Specialist3 yearsMORTGAGE104433.0Source VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68476807NaNmajor_purchaseMajor purchase174xxPA25.371.0Jun-1998695.0699.03.012.0NaN12.00.021929.064.535.0w0.000.0011740.50000011740.5010400.001340.500.00.00.0Jul-201610128.96NaNMar-2018704.0700.00.0NaN1.0IndividualNaNNaNNaN0.00.0331730.01.03.00.03.014.073839.084.04.07.09702.078.034000.02.01.03.010.027644.04567.077.50.00.0128.0210.04.04.06.04.012.01.012.00.04.06.05.09.010.07.019.06.012.00.00.00.04.096.660.00.00.0439570.095768.020300.088097.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
568426831NaN11950.011950.011950.036 months13.44405.18CC3Veterinary Tecnician4 yearsRENT34000.0Source VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68426831NaNdebt_consolidationDebt consolidation300xxGA10.200.0Oct-1987690.0694.00.0NaNNaN5.00.08822.068.46.0w0.000.0013708.94853013708.9511950.001758.950.00.00.0May-20177653.56NaNMay-2017759.0755.00.0NaN1.0IndividualNaNNaNNaN0.00.012798.00.01.00.00.0338.03976.099.00.00.04522.076.012900.00.00.00.00.02560.0844.091.00.00.0338.054.032.032.00.036.0NaNNaNNaN0.02.03.02.02.02.04.04.03.05.00.00.00.00.0100.0100.00.00.016900.012798.09400.04000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
668476668NaN20000.020000.020000.036 months9.17637.58BB2Vice President of Recruiting Operations10+ yearsMORTGAGE180000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68476668NaNdebt_consolidationDebt consolidation550xxMN14.670.0Jun-1990680.0684.00.049.0NaN12.00.087329.084.527.0f0.000.0021393.80000021393.8020000.001393.800.00.00.0Nov-201615681.05NaNMar-2019654.0650.00.0NaN1.0IndividualNaNNaNNaN0.00.0360358.00.02.00.02.018.029433.063.02.03.013048.074.094200.01.00.01.06.030030.00.0102.90.00.0142.0306.010.010.04.012.0NaN10.0NaN0.04.06.04.05.07.09.016.06.012.00.00.00.02.096.3100.00.00.0388852.0116762.031500.046452.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
767275481NaN20000.020000.020000.036 months8.49631.26BB1road driver10+ yearsMORTGAGE85000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=67275481NaNmajor_purchaseMajor purchase293xxSC17.611.0Feb-1999705.0709.00.03.0NaN8.00.0826.05.715.0w0.000.0021538.50897721538.5120000.001538.510.00.00.0Jan-201714618.23NaNMar-2019674.0670.00.03.01.0IndividualNaNNaNNaN0.00.0141601.00.03.00.04.013.027111.075.00.00.0640.055.014500.01.00.02.04.017700.013674.05.70.00.0149.055.032.013.03.032.0NaN8.0NaN1.02.02.03.03.09.03.03.02.08.00.00.01.00.093.30.00.00.0193390.027937.014500.036144.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
868466926NaN10000.010000.010000.036 months6.49306.45AA2SERVICE MANAGER6 yearsRENT85000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68466926NaNcredit_cardCredit card refinancing160xxPA13.070.0Apr-2002685.0689.01.0NaN106.014.01.010464.034.523.0w0.000.0010998.97157510998.9710000.00998.970.00.00.0Aug-20181814.48NaNMar-2019719.0715.00.0NaN1.0IndividualNaNNaNNaN0.08341.027957.02.01.00.00.035.017493.057.02.07.02524.046.030300.02.00.01.07.01997.08182.050.10.00.0164.0129.01.01.01.04.0NaN1.0NaN0.06.09.07.010.03.013.019.09.014.00.00.00.02.095.728.61.00.061099.027957.016400.030799.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
968616873NaN8000.08000.08000.036 months11.48263.74BB5Vendor liaison10+ yearsMORTGAGE42000.0Not VerifiedDec-2015Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=68616873NaNcredit_cardCredit card refinancing029xxRI34.800.0Nov-1994700.0704.00.075.0NaN8.00.07034.039.118.0w0.000.008939.5805038939.588000.00939.580.00.00.0Apr-20174996.24NaNNov-2018679.0675.00.075.01.0IndividualNaNNaNNaN0.00.0199696.00.02.02.03.010.0106748.072.00.02.04725.049.018000.00.00.01.05.028528.09966.041.40.00.0155.0253.015.010.01.050.0NaN10.0NaN1.03.03.03.06.05.05.011.03.08.00.00.00.02.094.433.30.00.0256513.0113782.017000.0135513.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN

Last rows

idmember_idloan_amntfunded_amntfunded_amnt_invtermint_rateinstallmentgradesub_gradeemp_titleemp_lengthhome_ownershipannual_incverification_statusissue_dloan_statuspymnt_planurldescpurposetitlezip_codeaddr_statedtidelinq_2yrsearliest_cr_linefico_range_lowfico_range_highinq_last_6mthsmths_since_last_delinqmths_since_last_recordopen_accpub_recrevol_balrevol_utiltotal_accinitial_list_statusout_prncpout_prncp_invtotal_pymnttotal_pymnt_invtotal_rec_prncptotal_rec_inttotal_rec_late_feerecoveriescollection_recovery_feelast_pymnt_dlast_pymnt_amntnext_pymnt_dlast_credit_pull_dlast_fico_range_highlast_fico_range_lowcollections_12_mths_ex_medmths_since_last_major_derogpolicy_codeapplication_typeannual_inc_jointdti_jointverification_status_jointacc_now_delinqtot_coll_amttot_cur_balopen_acc_6mopen_act_ilopen_il_12mopen_il_24mmths_since_rcnt_iltotal_bal_ilil_utilopen_rv_12mopen_rv_24mmax_bal_bcall_utiltotal_rev_hi_liminq_fitotal_cu_tlinq_last_12macc_open_past_24mthsavg_cur_balbc_open_to_buybc_utilchargeoff_within_12_mthsdelinq_amntmo_sin_old_il_acctmo_sin_old_rev_tl_opmo_sin_rcnt_rev_tl_opmo_sin_rcnt_tlmort_accmths_since_recent_bcmths_since_recent_bc_dlqmths_since_recent_inqmths_since_recent_revol_delinqnum_accts_ever_120_pdnum_actv_bc_tlnum_actv_rev_tlnum_bc_satsnum_bc_tlnum_il_tlnum_op_rev_tlnum_rev_acctsnum_rev_tl_bal_gt_0num_satsnum_tl_120dpd_2mnum_tl_30dpdnum_tl_90g_dpd_24mnum_tl_op_past_12mpct_tl_nvr_dlqpercent_bc_gt_75pub_rec_bankruptciestax_lienstot_hi_cred_limtotal_bal_ex_morttotal_bc_limittotal_il_high_credit_limitrevol_bal_jointsec_app_fico_range_lowsec_app_fico_range_highsec_app_earliest_cr_linesec_app_inq_last_6mthssec_app_mort_accsec_app_open_accsec_app_revol_utilsec_app_open_act_ilsec_app_num_rev_acctssec_app_chargeoff_within_12_mthssec_app_collections_12_mths_ex_medsec_app_mths_since_last_major_deroghardship_flaghardship_typehardship_reasonhardship_statusdeferral_termhardship_amounthardship_start_datehardship_end_datepayment_plan_start_datehardship_lengthhardship_dpdhardship_loan_statusorig_projected_additional_accrued_interesthardship_payoff_balance_amounthardship_last_payment_amountdisbursement_methoddebt_settlement_flagdebt_settlement_flag_datesettlement_statussettlement_datesettlement_amountsettlement_percentagesettlement_term
226069189996426NaN32000.032000.032000.060 months14.49752.74CC4Sales Manager3 yearsMORTGAGE157000.0Source VerifiedOct-2016Charged Offnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89996426NaNhome_improvementHome improvement863xxAZ10.340.0Jun-2011735.0739.00.0NaNNaN14.00.0111598.027.418.0f0.000.003737.9400003737.941876.471861.470.000.00.0Mar-2017752.74NaNDec-2018499.00.00.0NaN1.0IndividualNaNNaNNaN0.00.0408701.02.02.00.02.016.011274.047.02.07.0736.036.0207500.02.02.00.010.029193.014118.010.60.00.053.063.04.04.03.04.0NaN15.0NaN0.05.08.07.07.04.011.011.08.014.00.00.00.02.0100.00.00.00.0524379.0122872.015800.023879.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069290006534NaN16000.016000.016000.060 months12.79362.34CC1Manager10+ yearsRENT150000.0Not VerifiedOct-2016Fully Paidnhttps://lendingclub.com/browse/loanDetail.action?loan_id=90006534NaNmedicalMedical expenses284xxNC12.250.0Aug-1997665.0669.00.068.026.012.04.07700.055.028.0f0.000.0018660.60756918660.6116000.002660.610.000.00.0Mar-201812874.54NaNMar-2019684.0680.00.068.01.0IndividualNaNNaNNaN0.00.065797.01.05.02.06.04.058097.079.00.03.04516.075.014000.01.01.01.09.05982.02720.073.10.00.0147.0229.017.04.00.017.0NaN12.0NaN1.03.04.04.05.015.06.011.04.012.00.00.00.02.092.050.03.00.087473.065797.010100.073473.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069389955820NaN24000.024000.024000.060 months10.49515.74BB3Current Operations Officer4 yearsOWN125000.0Not VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89955820NaNcredit_cardCredit card refinancing967xxHI10.980.0Feb-2001725.0729.00.0NaN42.015.02.022448.022.422.0f13951.4313951.4314977.43000014977.4310048.574928.860.000.00.0Mar-2019515.74Apr-2019Mar-2019739.0735.00.0NaN1.0IndividualNaNNaNNaN0.00.031320.05.01.00.00.044.08872.031.05.010.06460.024.0100300.00.00.00.010.02088.073489.021.60.00.044.0187.00.00.00.00.0NaN13.0NaN0.06.08.011.014.01.014.021.08.015.00.00.00.05.0100.00.00.02.0128902.031320.093700.028602.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069489885898NaN24000.024000.024000.060 months12.79543.50CC1Unit Operator7 yearsMORTGAGE95000.0Source VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=89885898NaNhome_improvementHome improvement356xxAL19.610.0Dec-1999665.0669.00.0NaNNaN5.00.049431.084.454.0f14287.3914287.3915760.50000015760.509712.616047.890.000.00.0Mar-2019543.50Apr-2019Mar-2019709.0705.00.0NaN1.0IndividualNaNNaNNaN0.00.0104422.02.02.01.03.03.054991.0106.02.02.00.0103.050500.01.019.01.05.026106.0NaNNaN0.00.0201.088.03.03.00.0NaNNaN4.0NaN0.00.02.00.03.043.03.011.02.05.00.00.00.03.0100.0NaN0.00.0102517.0104422.00.052017.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069588977788NaN24000.024000.024000.060 months10.49515.74BB3Database Administrator10+ yearsMORTGAGE108000.0Not VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88977788NaNdebt_consolidationDebt consolidation840xxUT34.940.0Feb-1991695.0699.01.060.069.024.01.021665.039.058.0f13951.4213951.4215008.53000015008.5310048.584959.950.000.00.0Mar-2019515.74Apr-2019Mar-2019734.0730.00.060.01.0IndividualNaNNaNNaN0.00.0140118.00.04.00.05.016.0118453.077.00.02.04090.059.055600.01.012.04.07.06369.015307.045.10.00.0166.0307.015.015.04.015.060.04.060.012.05.012.07.018.017.019.037.012.024.00.00.00.00.075.942.90.01.0227883.0140118.027900.0172283.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069688985880NaN40000.040000.040000.060 months10.49859.56BB3Vice President9 yearsMORTGAGE227000.0VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88985880NaNdebt_consolidationNaN907xxCA12.757.0Feb-1995705.0709.01.09.0NaN5.00.08633.064.937.0f23252.5923252.5924903.93000024903.9316747.418156.520.000.00.0Mar-2019859.56Apr-2019Mar-2019724.0720.00.010.01.0IndividualNaNNaNNaN0.00.028398.00.02.00.01.015.019765.046.00.00.05141.051.013300.03.00.02.02.05680.04070.066.90.00.0154.0258.033.015.03.041.09.01.09.06.02.03.02.015.09.03.023.03.05.00.00.07.00.075.750.00.00.055970.028398.012300.042670.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
226069788224441NaN24000.024000.024000.060 months14.49564.56CC4Program Manager6 yearsRENT110000.0Not VerifiedOct-2016Charged Offnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88224441NaNdebt_consolidationDebt consolidation334xxFL18.300.0Jul-1999660.0664.00.067.072.010.01.017641.068.131.0f0.000.006755.4000006755.403521.913233.490.000.00.0Oct-2017564.56NaNMar-2019594.0590.00.067.01.0IndividualNaNNaNNaN0.00.062426.00.02.00.02.020.044785.078.01.05.06172.073.025900.00.00.01.07.06243.04660.077.50.00.0132.0206.09.09.02.09.0NaN9.0NaN1.05.07.05.015.04.08.024.07.010.00.00.00.01.096.240.01.00.084664.062426.020700.058764.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashYMar-2019ACTIVEMar-201910000.044.821.0
226069888215728NaN14000.014000.014000.060 months14.49329.33CC4Customer Service Technician10+ yearsMORTGAGE95000.0VerifiedOct-2016Currentnhttps://lendingclub.com/browse/loanDetail.action?loan_id=88215728NaNdebt_consolidationNaN770xxTX23.360.0Jun-1996660.0664.01.037.0NaN8.00.07662.054.022.0w8456.128456.129621.2500009621.255543.884027.9649.410.00.0Mar-2019329.33Apr-2019Mar-2019669.0665.00.037.01.0IndividualNaNNaNNaN0.00.0143066.00.01.01.02.07.032071.094.00.01.04093.084.014200.03.01.02.03.017883.01838.080.70.00.0149.0243.022.07.01.075.039.06.037.04.03.03.04.012.03.05.017.03.08.00.00.00.01.081.850.00.00.0163804.044215.09500.034169.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCashNNaNNaNNaNNaNNaNNaN
2260699Total amount funded in policy code 1: 1465324575NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2260700Total amount funded in policy code 2: 521953170NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN